HELP: invalid SQL statement !

From: Thib <Philippart_at_geru.ucl.ac.be>
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

Original text of this message