Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Finding which field of many is too large in a SQL statement...

Re: Finding which field of many is too large in a SQL statement...

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 4 Oct 2006 08:05:00 -0700
Message-ID: <1159974299.923383.113770@b28g2000cwb.googlegroups.com>

dean wrote:
> > I take you are asking if you can find this information in ADO code and
> > I do not know ADO. If you code in a Pro* language Oracle provides
> > structures that are used to communicate with the database. Parse
> > errors are stored in the SQLCA structure variable sqlca.sqlerrd[4]. If
> > ADO gives you access to the SQLCA structure then the answer is yes,
> > otherwise you are probably out of luck
> >
> > HTH -- Mark D Powell --
>
> Hi Mark - I don't want to query ADO per se, I want to know if there is
> a table that I can query to find the last error message in my session
> (and extract the appropriate field). We do use pro-C for some things,
> but not in this case.
>
> Dean

No table or view that you can query that I can think of contains the parse information. With a pro* language program you can get it but most interfaces do not make this information available.

Received on Wed Oct 04 2006 - 10:05:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US