HELP: invalid SQL statement ! (2)
Date: 1998/04/03
Message-ID: <3524F689.A702C37B_at_geru.ucl.ac.be>#1/1
This message could be better that the previous I sent...
Hi,
[Quoted] I work with Oracle 8.0.3 and I have a problem.
I would like to use the "ACCEPT var PROMPT string" statement in my SQL worksheet and it doesn't work very good...
In SQL*Plus, I write: ACCEPT var_test Prompt 'Enter value :'. That's fine, it works. But if I save this line in an SQL file and then if I run it, it fails and I receive the following message:
ORA-00900: invalid SQL statement
[Quoted] Why ? Is ACCEPT really an SQL command ? I have the same problem with commands like "COLUMN name HEADER ..."
[Quoted] Now, I would like to include the ACCEPT command in a PL/SQL program. How can I do ? Please, can you help me ?
Thank you in advance for your help.
Best Regards,
ThibautReceived on Fri Apr 03 1998 - 00:00:00 CEST