Home » SQL & PL/SQL » Client Tools » Problems with Substitute Variable Prompts (Oracle 9i/SQLPlus Wksheet)
Problems with Substitute Variable Prompts [message #440397] Sat, 23 January 2010 13:28 Go to next message
Darknss
Messages: 4
Registered: January 2010
Junior Member
Still kind of a beginner at this, but for some reason when I've tried to use substitute variables, they like to come up in 2's for the prompt. When I have the Set Verify option on, its even more disgusting.
Thank you for at least looking over my problem.


insert into orders
values(&order#, &customer#, &orderdate, &shipdate,
&shipstreet, &shipcity, &shipstate, &shipzip);



Enter value for order: Enter value for customer:


Re: Problems with Substitute Variable Prompts [message #440398 is a reply to message #440397] Sat, 23 January 2010 13:30 Go to previous messageGo to next message
BlackSwan
Messages: 25032
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

use CUT & PASTE so we can see exactly what you do & how Oracle responds

Re: Problems with Substitute Variable Prompts [message #440399 is a reply to message #440398] Sat, 23 January 2010 13:33 Go to previous messageGo to next message
Darknss
Messages: 4
Registered: January 2010
Junior Member
I did, that is exactly how it responded. I apologize for not using the code. I just saw that now and was going to edit it with the blue outline. But in response to your statement, I did cut and paste my command and exactly what Oracle output to me.
Re: Problems with Substitute Variable Prompts [message #440400 is a reply to message #440399] Sat, 23 January 2010 13:43 Go to previous messageGo to next message
Darknss
Messages: 4
Registered: January 2010
Junior Member
Apologies for not using the code the first time to isolate my SQL. The first portion is my command and the 2nd part is Oracle's response. Both are cut and pasted directly from the SQL+ Worksheet interface.

insert into orders
values(&order#, &customer#, &orderdate, &shipdate,
      &shipstreet, &shipcity, &shipstate, &shipzip);



Enter value for order: Enter value for customer: 


Re: Problems with Substitute Variable Prompts [message #440401 is a reply to message #440400] Sat, 23 January 2010 13:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do not use "SQL+ Worksheet interface", use SQL*Plus standard, retry and copy and paste what you have, then you can see if the problem comes from the script or the interface.

Regards
Michel

[Updated on: Sat, 23 January 2010 13:46]

Report message to a moderator

Re: Problems with Substitute Variable Prompts [message #440402 is a reply to message #440401] Sat, 23 January 2010 13:55 Go to previous messageGo to next message
Darknss
Messages: 4
Registered: January 2010
Junior Member
Thank you very much, it worked just fine under the standard. I'd been using the worksheet plus ever since I started the class, I didn't really even know about standard version. It's mainly an online class, so there isn't a lot of interaction with the teacher. Thanks again for your help, sorry if it was such a simple solution.

TD
icon12.gif  Re: Problems with Substitute Variable Prompts [message #440425 is a reply to message #440402] Sun, 24 January 2010 07:08 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
You could also download and use SQL Developer instead (free from Oracle), this is the latest evolution of "Worksheet".

[Updated on: Sun, 24 January 2010 08:37] by Moderator

Report message to a moderator

Re: Problems with Substitute Variable Prompts [message #440427 is a reply to message #440425] Sun, 24 January 2010 08:38 Go to previous message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A bad idea when you want to learn.

Regards
Michel

[Updated on: Sun, 24 January 2010 08:39]

Report message to a moderator

Previous Topic: Interface screen for Oracle database
Next Topic: ORA-12514
Goto Forum:
  


Current Time: Fri Dec 02 12:17:20 CST 2016

Total time taken to generate the page: 0.07976 seconds