| ORA-06508 [message #133467] |
Fri, 19 August 2005 04:14  |
kate99
Messages: 24
Registered: July 2005
|
Junior Member |
|
|
I got this error in runtime:
FRM-40735: when-button-pressed trigger raised unhandled exception ORA-06508.
ORA-06508: PL/SQL: could not find program unit being called.
It is because I used 'rp2rro.rp2rro_run_product' in the code. 'rp2rro.rp2rro_run_product' is in the RP2RRO library. I tried detach and reattach the library, but it didn't help. Any suggestion?
Thanks,
Kate
|
|
|
|
| Re: ORA-06508 [message #133470 is a reply to message #133467] |
Fri, 19 August 2005 04:21  |
kiran
Messages: 503
Registered: July 2000
|
Senior Member |
|
|
Just seen the error code.It says that "tried to call an stored procedure which is not exist".
Try complining library first and check out the error.
And if possible post your code.
--Kiran.
|
|
|
|
| Re: ORA-06508 [message #133597 is a reply to message #133470] |
Fri, 19 August 2005 20:40 |
kate99
Messages: 24
Registered: July 2005
|
Junior Member |
|
|
The RP2RRO library was came with 9iDS. It's under /forms90 in 9iDS home directory.
The code is too long to be posted here. But the piece of code was modified by Migration Assistant when I used it to convert Forms6i to Forms9i. It changed the code from:
run_product(REPORTS, 'other_info', SYNCHRONOUS, RUNTIME, FILESYSTEM, par_list, NULL);
to
rp2rro.rp2rro_run_product(REPORTS, 'other_info', SYNCHRONOUS, RUNTIME, FILESYSTEM, par_list, NULL);
Thanks!
|
|
|
|
| Re: ORA-06508 [message #133704 is a reply to message #133597] |
Sun, 21 August 2005 18:59 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Are you having this problem in the DS or AS?
If the problem is in your DS then copy the RP2RRO library to your work directory, recompile it and then regenerate it.
If the problem is in your AS then copy the RP2RRO library from your development area to your test directory and then regenerate it.
Did you attach the library to your form? Did you use the default 'No' to 'Remove path' (which is wrong) or manually change to use 'Yes' to 'remove directory path'?
Update: Sorry, I had them around the wrong way.
David
[Updated on: Sun, 21 August 2005 21:01] Report message to a moderator |
|
|
|
| Re: ORA-06508 [message #133715 is a reply to message #133704] |
Sun, 21 August 2005 20:24 |
kate99
Messages: 24
Registered: July 2005
|
Junior Member |
|
|
Hi David,
It happens in DS. I did copy the library to the work directory and recompiled the form. When I attached the library, it asked: "Attached library name D:\project\rp2rro.pll contains a non-portable directory specification. Remove path?" So I chose 'Yes' to remove the path. But the error is still there.
Thanks,
Kate
|
|
|
|
| Re: ORA-06508 [message #133718 is a reply to message #133715] |
Sun, 21 August 2005 21:03 |
|
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
No ... not compile the form,
Initially, close the form builder, open it again, open the pll as a file, compile and generate it, save it, and close the form builder. Reopen the form builder again, open your form, attach the library, then compile and generate the form, then save it and run it.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
