Home » Developer & Programmer » Forms » How to call a SQL*Report from Oracle Forms Developer
How to call a SQL*Report from Oracle Forms Developer [message #82505] Sun, 01 June 2003 23:02 Go to next message
Partha
Messages: 4
Registered: September 2001
Junior Member
Hi,

Our application is running on a Web based 3 tier architecture. We have a requirement to run a *.sql file and spool the output file on the middle-tier. Do let me know how to do the same from Oracle Forms ?. I know that we can invoke SQL*Plus from Forms using the host command. But, how to run the sql file from Forms ?.
Re: How to call a SQL*Report from Oracle Forms Developer [message #82508 is a reply to message #82505] Mon, 02 June 2003 04:34 Go to previous messageGo to next message
Maaher
Messages: 7064
Registered: December 2001
Senior Member
plus80w username/password@yourdb @c:tempsomefile.sql
is the command line layout to invoke (in my case the GUI version) of SQLPlus.

Put it in a HOST and it should work.

MHE
Re: How to call a SQL*Report from Oracle Forms Developer [message #82514 is a reply to message #82508] Mon, 02 June 2003 09:07 Go to previous messageGo to next message
Eduardo Ferrari
Messages: 2
Registered: June 2003
Junior Member
You can use the RUN_PRODUCT function as the example below:

Run_Product(REPORTS, 'empreport', SYNCHRONOUS, RUNTIME, FILESYSTEM, pl_id, NULL);

Hope it helps.

Eduardo Ferrari
Stefanini IT Solutions - Brazil
Re: How to call a SQL*Report from Oracle Forms Developer [message #82522 is a reply to message #82508] Tue, 03 June 2003 02:58 Go to previous messageGo to next message
magnetic
Messages: 324
Registered: January 2003
Senior Member
database versions 8i and above does not support the term "plus80w" anymore. it should be "sqlplus".
sqlldr73/80 --> sqlldr en so on...
Re: How to call a SQL*Report from Oracle Forms Developer [message #82533 is a reply to message #82505] Thu, 05 June 2003 05:06 Go to previous message
Zaire
Messages: 36
Registered: October 2002
Member
Try this using the host command:

host('sqlplus username/password@database @filedir:filename.sql');
Previous Topic: Database to excel
Next Topic: Order of firing
Goto Forum:
  


Current Time: Mon May 16 19:10:02 CDT 2022