This content has been marked as final. Show 12 replies
when migrating from 6i to 10g we have used the wizard to replace RUN_PRODUCT with rp2rro.rp2rro_run_product (rp2rro.pll).
The wizard has a config file (search_replace.properties) where you can specify replacement functions.
I do not now where is this in 11g
Hi Thanks for your reply,
Yes in some of the code the run_product was replaced with rp220_run_product, but i think they didn't do it properly.
but the problem is it's a read only stored procedure. And i don't know how to edit the PLSQL.
can you please tell me how to edit that file
I'm a little confused.1 person found this helpful
you can not use RUN_PRODUCT within stored procedure (in DB) !
you mean by read only = the procedure (in Forms) is wrapped
In this case you can not change anything.
Edited by: alinzenb on 14.11.2012 09:15
Yeah, The Procedure in forms is wrapped and can not edit anything in there. So if it's impossible to edit how can i get rid of the compilation error. Forms Builder giving a PL/SQL error and i can not generate the FMX.
i appreciate you helping me, Thanks
Finally I solved the problem, it's wrapped in the form, but i was able to find the source for the procedure. It's in the PLL attached and i was able to change the code in the PLL file, and now all the forms that are calling reports getting complied without any errors.
I guess it's a basic thing but I'm new to migrating so just learning stuff.
Thanks for your help.
I'm facing the same error "RUN_PRODUCT" must be declared while upgrading a form from 10g to 11g version.
Please provide the solution.
Thanks in advance.
The solution is to look in the docs on how to use RUN_REPORT_OBJECT built-in.
If you google for this there are many examples.
run_product is not available anymore in forms 11g. depending on what you want to run (reports,...) there are different implementations, so you'd have to tell us what you are using run_product for. And most certainly this has been asked before, so the forum search/google should give you a good starter on how to overcome your problem easily ;)
Oh and by the way: as you upgraded from 10g to 11g you probably could simply remove the call to run_product as in 10g the built-in was available but simply didn't do anything. So you are probably facing dead code.
First of all thanks for your responses.
Still I can't able to overcome this error.
Form has been successfully compiled in 10g version. Its giving error in 11g version. We are calling a report from Form using run_product built-in. But its not working in 11g.
I'm new to Oracle Forms.
Please provide steps to resolve this error.
Your help is highly appreciated.
Edited by: 1004743 on May 8, 2013 3:58 AM
You are replying to an old thread, but it looks like you didn't read it properly. It is stated that
when migrating from 6i to 10g we have used the wizard to replace RUN_PRODUCT with rp2rro.rp2rro_run_product (rp2rro.pll).So, you also need to use rp2rro.pll if you still want to make use of RUN_PRODUCT. Even in 10g RUN_PRODUCT by itself won't work. As Christian already said:
you probably could simply remove the call to run_product as in 10g the built-in was available but simply didn't do anything.Did you try that yet?
With the Conversion Tool Pitss.Con you can do a global change to all Forms and Libraries. In your particular case it will replace all run_product with rp2rro.rp2rro_run_product and does all need changes like adding the rp2rro Reports object aso.