reference is out of scope
i've a bi report but when run. it prompts an error below PLS-00225: subprogram or cursor 'PROC_NAME' reference is out of scope
was wondering where could be the error since the procedure works fine when run in toad.
attached my data template and procedure...
Request ID: 32588636
All Parameters: P_SOURCE=OLS:P_DATEFROM="2010/07/01 00:00:00":P_DATETO="2010/07/30 00:00:00"
Data Template Code: PROC_NAME
Data Template Application Short Name: XBOL
Debug Flag: N
{P_SOURCE=OLS, P_DATETO=2010/07/30 00:00:00, P_DATEFROM=2010/07/01 00:00:00}
Calling XDO Data Engine...
[082511_025908280][][EXCEPTION] SQLException encounter while executing data trigger....
java.sql.SQLException: ORA-06550: line 2, column 22:
PLS-00225: subprogram or cursor 'PROC_NAME' reference is out of scope