Fantastic! That should be just the thing I'm looking for. Thank you! -dpf-
----------------------- David P. Fannin Database Administrator [EMAIL PROTECTED] UM-Rolla Information Technology FAX (573) 341-4216 URL http://www.umr.edu/~dpf PHONE (573) 341-6375 ----------------------- -----Original Message----- From: Andy Hassall [mailto:[EMAIL PROTECTED] Sent: Monday, April 19, 2004 3:35 PM To: Fannin, David P.; [EMAIL PROTECTED] Subject: RE: Locating error position in DBD::Oracle Yes, use $dbh->{ora_parse_error_offset} - added in DBD::Oracle 1.15, although I forgot to submit a documentation patch along with it at the time - it's documented in the latest development version. -- Andy Hassall <[EMAIL PROTECTED]> / Space: disk usage analysis tool <http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space> > -----Original Message----- > From: Fannin, David P. [mailto:[EMAIL PROTECTED] > Sent: 19 April 2004 14:24 > To: [EMAIL PROTECTED] > Subject: Locating error position in DBD::Oracle > > Some sql editors, such as sqlplus, seem to be able to locate the > position within an SQL statement where a syntax error occurs. I have > looked through the DBD::Oracle documentation and have not been able to > find such a thing mentioned. Does DBD::Oracle support this, or is it > a feature that can not be accessed via the libraries provided by > Oracle? It would be an ever so handy feature to have -- if for no > other reason than to keep me from having to use sqlplus. :) > > Thanks! > > -dpf- > > ----------------------- > David P. Fannin > Database Administrator [EMAIL PROTECTED] > UM-Rolla Information Technology FAX (573) 341-4216 > URL http://www.umr.edu/~dpf PHONE (573) 341-6375 > ----------------------- > >