HELP: invalid SQL statement ! (2)

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

                                                    Thibaut
Received on Fri Apr 03 1998 - 00:00:00 CEST

Original text of this message