Home » SQL & PL/SQL » SQL & PL/SQL » Calling report from PL/SQL
Calling report from PL/SQL [message #38684] Mon, 06 May 2002 05:19 Go to next message
Bud
Messages: 1
Registered: May 2002
Junior Member
I need to call a report (using r25run32) from PL/SQL. I have done it from the command line and VB, but can't find a way to do it with PL/SQL. An alternative would be to call from C++ using something like...
cmd.Format( "r25run32.exe userid=%s/%s@yad3 report=%s batch=yes destype=file desname=c:QAReport2.pdf desformat=pdf sel_code=%s","instance","pw","r5prpord.rep","N00000290000");
//cmd.Format("r25run32.exe");
//cmd2.Format("userid=%s/%s@yad3 report=%s batch=yes destype=file desname=c:syncpowrbinQAReport.pdf desformat=pdf sel_code=%s","irdev","finally","r5prpord.rep",pPK1);
cmd2="c:southernorantbin";

MessageBox( NULL, cmd, "Create_QA_Record", MB_OK );


ret=execl(cmd2,cmd,0);
Re: Calling report from PL/SQL [message #38739 is a reply to message #38684] Thu, 09 May 2002 11:31 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
To run an external command on the Oracle server, you can use a Java stored procedure, C (or whatever) library or DBMS_PIPE (and maybe some others too).
search on asktom.oracle.com
Previous Topic: Database Independency
Next Topic: Re: error to SET AUTO TRACE ON
Goto Forum:
  


Current Time: Tue May 07 11:37:31 CDT 2024