Quote:
Originally posted by kondaoracle
Hi n_i
can u pls make it more clear...
in my pl/sql i sud write /nolog ? thats what u r mentioning or
see the following
30 1 * * 1 . /home/yourloginid/.profile;sqlplus /nolog @/usr/myProc/procSample.sql
|
You can connect to a database by two methods, as you probably know:
1) specify userid, password, and service name on the sqlplus command line:
sqlplus userid/pass@svcname @script.sql
2) specify /nolog on the sqlplus command line, like this:
sqlplus /nolog @script.sql
and then use CONNECT command within the script
See SQLplus reference manual for more details