problem creating an executable procedure [message #195653] |
Sat, 30 September 2006 06:12 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
it_me24
Messages: 167 Registered: March 2006 Location: delhi
|
Senior Member |
|
|
Hello Everyone!
I want to create an executable procedure, n did something like:
-> created the procedure p1 and
-> created the batch file test.bat as
c:\oracle\admin\bin\sqlplus.exe
connect system/manager@db1
execute p1;
n when i double click on the test.bat file, i get sqlplus login name n password.
?????????why it is prompting me for username n password, when i have already specified that in batch file.
thanks in advance.
|
|
|
|
Re: problem creating an executable procedure [message #195911 is a reply to message #195653] |
Tue, 03 October 2006 02:24 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
it_me24 | why it is prompting me for username n password, when i have already specified that in batch file.
| Yes, you did, but in the wrong place. At the moment you called SQLPLUS.EXE to be executed, .BAT script terminated its execution (sort of; perhaps it would be better to say paused) and the focus was now on SQL*Plus session, not OS command prompt's.
To connect to SQL*Plus, you are required to enter valid credentials - username, password (and, optionally, database) - and that's it.
|
|
|
|
|
Re: problem creating an executable procedure [message #196159 is a reply to message #195653] |
Wed, 04 October 2006 06:27 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
it_me24
Messages: 167 Registered: March 2006 Location: delhi
|
Senior Member |
|
|
I want to create an executable procedure, n i have created the batch file as shown above.
but when i am double clicking on batch file which i created , i get SQL PLUS login screen, which asks me to enter the username n password.
My question is Why is it not taking the username n passwd from batch file.
Appreciating Response
|
|
|
|
|
|
|