| Re: Pass parameters to sqlplus [message #374783] |
Mon, 02 July 2001 10:04  |
Sunil
Messages: 132
Registered: September 1999
|
Senior Member |
|
|
Problem is that the sql file will be uploaded by the user. I do not have control over anything that is entered in the script file.
Sunil.
|
|
|
|
| Re: Pass parameters to sqlplus [message #374784 is a reply to message #374783] |
Mon, 02 July 2001 10:31  |
Bala
Messages: 205
Registered: November 1999
|
Senior Member |
|
|
Hi,
I got you.
Then you have to have some scripting
DOS or shell (Win/unix) to add those settings and make a temp copy of that file and execute them.
like in windows
instead of
SqlPlus UserName/PassWord @MyScript.sql
you will do
@echo set colsep ',' > c:\temp\myscript.sql
@echo set linesize 200 >> c:\temp\myscript.sql
@type c:\scripts\myscript.sql >> c:\temp\myscript.sql
@echo set colsep " " >> c:\temp\myscript.sql
@echo linesize 72 >> c:\temp\myscript.sql
SqlPlus UserName/PassWord @c:\temp\MyScript.sql
I don't know any thing about your set up, batch or interactive?
And i am not sure whether you can use the above example.
Bala.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
