OraFAQ Forum: Forms » How to call a SQL*Report from Oracle Forms Developer

Home » Developer & Programmer » Forms » How to call a SQL*Report from Oracle Forms Developer

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to call a SQL*Report from Oracle Forms Developer [message #82505]

Sun, 01 June 2003 23:02

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 ?.

Report message to a moderator

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

Maaher
Messages: 7065
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

Report message to a moderator

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

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

Report message to a moderator