Home » SQL & PL/SQL » Client Tools » parameters to SQLPLUS
parameters to SQLPLUS [message #229586] Mon, 09 April 2007 05:15 Go to next message
rzkhan
Messages: 345
Registered: March 2005
Senior Member
hi all..
could I pass parameter from forms6i to sqlplus? if so, an example please..


rzkhan
Re: parameters to SQLPLUS [message #229632 is a reply to message #229586] Mon, 09 April 2007 07:52 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
What do you want to do? Why don't you just do it in forms?
Re: parameters to SQLPLUS [message #229751 is a reply to message #229586] Mon, 09 April 2007 22:49 Go to previous messageGo to next message
rzkhan
Messages: 345
Registered: March 2005
Senior Member
I am passing a script file to SQLPlus, doing some calculations and displaying the output on sql. I also spool the result to a file where I could check the errors found during the script running...

I am sure it would be sufficient for you to help me in the situation.

rzkhan
Re: parameters to SQLPLUS [message #229757 is a reply to message #229586] Mon, 09 April 2007 23:00 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
A bad idea, invoking a kludge, resulting in Rube Golberg collection of s/w which will have problem passing audit.

FORMS6 as in obsoleted & unsupported product which runs in client/server mode?
Re: parameters to SQLPLUS [message #229805 is a reply to message #229757] Tue, 10 April 2007 01:47 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
@anacedent: I've recently seen a Forms 6 installation on a client running in client/server mode. The reason why the client refuses to upgrade is that the Forms modules control machinery on the plant. Don't jump into conclusions too soon Wink

@rzkhan: I'd opt for a (packaged) procedure to write files. Don't do it through SQL*plus but use UTL_FILE to write files.

Edit: since you're not accepting Private Messages: your report has been deleted. If you need more informations, PM me.

MHE

[Updated on: Wed, 11 April 2007 01:34]

Report message to a moderator

Re: parameters to SQLPLUS [message #230082 is a reply to message #229586] Tue, 10 April 2007 16:42 Go to previous message
Bill B
Messages: 1482
Registered: December 2004
Senior Member
if you are using oracle forms you can use utl_file to write/read files to the database server or the TEXT_IO package in forms to read/write to flat files on the client machine.
Previous Topic: isqlplus session time
Next Topic: SQL*Loader using TOAD
Goto Forum:
  


Current Time: Sun Dec 04 12:46:13 CST 2016

Total time taken to generate the page: 0.12346 seconds