Internal and Fatal Plsql Error in Oracle Report 10g

[Gurujothi D]

Hi everyone,In Report Builder, it has two parameters: start date and post through date.
Report is compiling fine but when I am running this report and generating XML from the Report Builder then it is having the error
REP-0069: internal error,
REP-57054: in-process job terminated,
REP-1401: Fatal PL/SQL error occurred .

can anyone suggest me how to solve this errors.
Thank you.

[r035198x]

Are you able to run the report query (using pl/sql or some other db tool) fine with the parameters you are passing?

[Gurujothi D]

Internal and Fatal Plsql Error in Oracle Report 10g

yeah its running! Mr.r035198x

[r035198x]

Does it give the error if you choose dates that result in very few records?

[Gurujothi D]

Sorry I dont know lot about this things,lot of parameters are there in which am entering these parameters in the parameter value input form,
p_ca_set_of_boo ks_id='2021'
p_start_date='2 012/01/01 00:00:00'
p_post_through_ date='2012/01/31 00:00:00'
p_ra_id='-999'
p_crh_id='-999'
p_mcd_id='-999'
p_ctlgd_id='-999'
p_adj_id='-999'
p_th_id='-999'
also other parameter also there but its filled default

[suraj17]

I am getting the same error 1401.
Does it give the error if you choose dates that result in very few records? --NO (output is displayed for few records)

For more records? --YES (output not displayed resulting in error 1401