Re: Purge command

From: William Robertson <>
Date: Mon, 6 Oct 2008 09:40:03 -0700 (PDT)
Message-ID: <>

On Oct 4, 7:34 am, "astalavista" <> wrote:
> <The 9i client doesn't know 10g SQL. If you call your command from the
> <9i client but wrapped in pl/sql the command will be executed in the
> <10g server successfully.
> SQL is not excuted by 10g engine ?
> some control is done by sql*plus ?

SQL*Plus does a very basic parse of the command to decide what it's dealing with, e.g. a SQL*Plus command like 'show linesize' that it can execute locally, or some SQL or PL/SQL that needs to go to the server. The type of command affects the continuation prompt, for example. If a command starts with BEGIN then it's PL/SQL and needs to continue until a line consisting of a "/" or a "." regardless of semicolons, if it starts with "SELECT" then it's SQL and ends with the first occurrence of the currently defined sqlterminator character, and so on. If you enter "BANANA" it gives an SP2-0042 "unknown command" error - notice that's raised by the SQL*Plus client and has not even gone to the server. As far as SQL*Plus 9i is concerned, 'PURGE' is in the same category (just like 'WITH' and 'MERGE' in SQL*Plus 8i). Received on Mon Oct 06 2008 - 11:40:03 CDT

Original text of this message