| parameters to SQLPLUS [message #229586] |
Mon, 09 April 2007 05:15  |
rzkhan
Messages: 370
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 #229751 is a reply to message #229586] |
Mon, 09 April 2007 22:49  |
rzkhan
Messages: 370
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 #229805 is a reply to message #229757] |
Tue, 10 April 2007 01:47 |
 |
Maaher
Messages: 7065
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 
@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 |
Bill B
Messages: 1971
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
