Re: Catch the very syntax error OUTSIDE SQL*Plus

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 28 Nov 2001 14:43:50 +0100
Message-ID: <u0dhri7bud8hd6@corp.supernews.com>

"Sri" <monsri_at_my-deja.com> wrote in message news:6425692a.0111280511.42003d96_at_posting.google.com...
> Hi,
> I'd like to know if there's a way of trapping
> the error you've made when you run a SQL statement,
> not only the SQL error number/text. You know SQL*Plus
> puts a mark (a '*') below the string that caused the
> error:
> > select count(1) from iit.giv_comtr
> > *
> > ERROR at line 1 :
> > ORA-00942: table or view does not exist
>
> This is what I'd like to be able to catch and to deal
> with, cause I'm performing my connections from Java...
>
> Is it specific to the SQL*Plus software, or is there a
> way of getting these very errors causes ?
>
> Thanks for any idea/help.
> Regs,
> Sri

It is specific to sql*plus
Of course you could always copy and paste your statement to a sql*plus window.
Shouldn't be that difficult I guess.

Hth Received on Wed Nov 28 2001 - 07:43:50 CST