|
|
|
|
| Re: calling report 6i from database trigger [message #285683 is a reply to message #285668] |
Wed, 05 December 2007 05:17   |
jitender.sadh
Messages: 86
Registered: May 2007
|
Member |
|
|
ok, is there any other method to call a report from database without using Java Stored Procedure, my mean by using any oracle built in package .
actualy i am trying to run the report by using following code in oracle 8i
1)create or replace trigger TRIGG1 after insert on emp
2)DECLARE
3) myPlist SRW_PARAMLIST;
4) myIdent SRW.Job_Ident;
5)BEGIN
6) myPlist := SRW_PARAMLIST(SRW_PARAMETER('',''));
7) --srw.add_parameter(myPlist,'GATEWAY','http://...');
8 --srw.add_parameter(myPlist,'SERVER','mySVR');
9) srw.add_parameter(myPlist,'REPORT','c:\myReport.RDF');
10) srw.add_parameter(myPlist,'USERID','scott/tiger');
11) myIdent := srw.run_report(myPlist);
12)END;
but i am getting errors.
SQL> show error
Errors for TRIGGER TRIGG1:
LINE/COL ERROR
-------- -----------------------------------------------------------------
2/12 PLS-00201: identifier 'SRW_PARAMLIST' must be declared
2/12 PL/SQL: Item ignored
3/12 PLS-00201: identifier 'SRW.JOB_IDENT' must be declared
3/12 PL/SQL: Item ignored
5/4 PLS-00320: the declaration of the type of this expression is incomplete or malformed
regard
jitender.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
