HELP: invalid SQL statement !
Date: 1998/04/03
Message-ID: <3524F423.26677A5F_at_geru.ucl.ac.be>#1/1
Hi,
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
Why ?
Is ACCEPT
really an
SQL
command ?
I have the
same
problem
with
commands
like
"COLUMN
name
HEADER
..."
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,
Thibaut Received on Fri Apr 03 1998 - 00:00:00 CEST