Hello,
I’ve upgraded to Toad for Oracle 12.6 from 11.5. A script that I “Execute via SQL Plus” to run other scripts, now closes instantly. The window should stay open and prompt me for a value. How do I fix this?
Thanks
If the value is a variable it must be a substitution variable and not a bind (i.e. &var and not :var).
Here’s the prompt:
spool &filename
It’s supposed to prompt me for the path and name of the spool file. But even it doesn’t like this for some reason, the sql plus window should stay open. Did a default value change for SQL Plus that causes the window to close automatically?
Thank you for the quick reply.
Perhaps you have a login,sql or glogin.sql file that’s calling SET DEFINE OFF (or SET DEF OFF). Try this…
SET DEFINE ON
spool &filename
If that doesn’t work then open a command prompt manually and start sqlplus and type your command. See if there’s some error connecting using sqlplus that’s causing the shutdown/prompt failure.
I had tried that, but I just tried again placing it directly above the spool prompt, and the same thing happened. Any other ideas?
Thanks!
Take Toad out of the equation and use SQLPlus manually with that script. Toad just calls the Windows routine to execute a command at shell. There’s nothing else really going on there. I suspect there’s some error message that you’re not seeing because the window is closing so rapidly. If there’s an error you’ll need to correct your setup before Toad will be able to call SQLPlus.
Michael,
Your answer was very helpful. I was able to determine that no matter how I set define, sqlplus does not prompt me for the variable. It may be that my installation did not complete successfully. Also, the home works differently in 12.5. I’m using a 64 bit instant client as well. I will open a ticket with Toad for this one.
Thanks again
I'd work on the sqlplus side first. If sqlplus isn't prompting for a variable when started manually at command prompt then something is wrong with your script or your setup, not with Toad. Try a simple script where you spool and select from dual. If that
works then incrementally add statements from your script until you see problems, etc. Apply standard debugging principles to isolate the cause, but do so in sqlplus, not sending to sqlplus via Toad. Reporting to support will likely trickle down to the dev
team and you've already got our attention here so start with sqlplus. If that's working as expected and Toad is not then post back or go to support.
On Nov 18, 2014, at 6:32 PM, Richard.Thomas bounce-RichardThomas@toadworld.com wrote:
Reply by Richard.Thomas
Michael,
Your answer was very helpful. I was able to determine that no matter how I set define, sqlplus does not prompt me for the variable. It may be that my installation did not complete successfully. Also, the home works differently in
12.5. I'm using a 64 bit instant client as well. I will open a ticket with Toad for this one.
Thanks again
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Richard,
If I am not mistaken, instant client doesn't come with SQL Plus. You have to install that on its own.
Greg
On Nov 18, 2014, at 6:32 PM, Richard.Thomas bounce-RichardThomas@toadworld.com wrote:
Reply by Richard.Thomas
Michael,
Your answer was very helpful. I was able to determine that no matter how I set define, sqlplus does not prompt me for the variable. It may be that my installation did not complete successfully. Also, the home works differently in
12.5. I'm using a 64 bit instant client as well. I will open a ticket with Toad for this one.
Thanks again
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.