Re: Purge command

OK thanks

"mathewbutler" <mathewbutler_at_yahoo.com> a écrit dans le message de news: 48803bee-3da5-48ab-b885-f98f85ea3557_at_j22g2000hsf.googlegroups.com... On Oct 4, 7:34 am, "astalavista" <nob..._at_nowhere.com> 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 ?
> Thanks

The client knows the SQL keywords and syntax - to enable SQL validation checks to take place without the expense of a trip to the server. In your case, it only knows about 9i SQL. To execute the 10G purge command you will need to send your statement as dynamic SQL ( purge is DDL) wrapped in PL/SQL. The PL/SQL block will be validated in the same way - keyword and syntax will be checked. However, the dynamic component will not be checked until execution time (after the PL/SQL has been shipped to the server and executed - on the server 10G SQL will be understood).

Try an anonymous PL/SQL block, with an "execute immediate" to make the call at runtime.

Mathew Butler Received on Tue Oct 07 2008 - 01:37:48 CDT