Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Finding which field of many is too large in a SQL statement...
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.