I'm running my app on Oracle Forms and Reports 11g R2 on Windows 64 bit. I have a Form App with a button which should open a report called "MYREPORT" whenever is pressed.
However, this buttons is not working as expected. PL/SQL code attached to it is the following: RP2RRO.RP2RRO_RUN_PRODUCT(REPORTS,'MYREPORT',SYNCHRONOUS,RUNTIME,FILESYSTEM,TO_CHAR(NULL),NULL);
MYREPORT.rep file is in c:\Oracle\Middleware\FR_HOME\reports\ directory.
I also updated the rwbuilder.conf file with the forms directory as mentioned above.
I must be missing something 'cause in that way it's not working, as well. A exception raises after button is pressed "Frm-40735: when-button=pressed trigger raise unhandled exception ora-06508".
Is there something else I could do in order to make it happen ?
I ran some tests and I got the exception below:
"SQLERRM: ORA-06508: PL/SQL: Could not find program unit being called".
Does anyone know how to deal with that?
Edited by: _blackjack on Dec 10, 2012 8:26 AM
I only have RP2RRO.pll in FORMS_PATH. There's no RP2RRO.plx in any directory. I've tried to generate .plx file through the Forms Developer but i did not succeed.
Is there any other way to get the .plx file?