| Run the Report in oracle froms 10g error [message #464382] |
Wed, 07 July 2010 11:33  |
kvkpraveen
Messages: 20
Registered: June 2010
Location: Bangalore
|
Junior Member |
|
|
Hi All,
i tried to run the report via oracle froms 10g in BUTTON CLICK. But i got the error like "FRM-41219 : CANNONT FIND REPORT:INVALID ID". I did the Following code.
DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status varchar2(20);
BEGIN
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'repserver01');
--SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,'PARAMFORM=NO P_DOC_NR='||:TBL_DOCUMENTS.DOC_PK);
repid := find_report_object('REPORT128');
v_rep := RUN_REPORT_OBJECT(repid);
rep_status := REPORT_OBJECT_STATUS(v_rep);
WHILE rep_status in('RUNNING','OPENING_REPORT','ENQUEUED')LOOP
rep_status := report_object_status(v_rep);
END LOOP;
Cheers!
Praveen.K
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
