Oracle Forms (MOSC)

MOSC Banner

Need Help converting RUN_PRODUCT to RUN_REPORT_OBJECT (converting from from 6i to 11g oracle forms)

edited May 8, 2013 3:47AM in Oracle Forms (MOSC) 8 commentsAnswered ✓
 What do I need to do with this code to make it work. Do I just replace RUN_OBJECT with RUN_REPORT_OBJECT?
PROCEDURE iproj_report(v VARCHAR2,s VARCHAR2,p VARCHAR2) IS
 pl_id paramlist;
BEGIN 
if p is not null then
 pl_id := Get_Parameter_List('tmpdata'); 
  IF NOT Id_Null(pl_id) THEN 
    Destroy_Parameter_List( pl_id); 
  END IF; 
  pl_id := Create_Parameter_List('tmpdata'); 
add_parameter(pl_id,'paramform',text_parameter,'yes'); 
--add_parameter(pl_id,'destype',text_parameter,'preview');
--add_parameter(pl_id,'orientation',text_parameter,'PORTRAIT');
add_parameter(pl_id,'the_where_clause',text_parameter,p);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center