enhancement: DBD::Oracle and OCI_ATTR_STMT_TYPE

Hi,

I'm an enthusiastic user of Perl DBI and DBD::Oracle. Thanks to Tim
Bunce and all the others who help maintain it!

I wrote a sort of SQL*Plus replacement called DBB which runs arbitrary
SQL statements and prints SELECT output with automatic column sizing
(readable instantly without any COLUMN x FORMAT), because I'm always
annoyed that SQL*Plus can't format it's output in a readable way. It
would be cool to have OCI_ATTR_STMT_TYPE available from DBD::Oracle.
Then I could provide feedback such as "ALTER Statement executed".
Currently there seems to be now way to find out what type of statement
was executed (i.e. ALTER, DELETE, INSERT).

DBB is included with my book "Secret ORACLE" which also has an intro to
DBI and DBD::Oracle: http://www.oradbpro.com/publications.html

Here's a quote from OCI doc:

Table 4–1 OCI_ATTR_STMT_TYPE Values and Statement Types

Attribute Value Statement Type

OCI_STMT_SELECT SELECT statement

OCI_STMT_UPDATE UPDATE statement

OCI_STMT_DELETE DELETE statement

OCI_STMT_INSERT INSERT statement

OCI_STMT_CREATE CREATE statement

OCI_STMT_DROP DROP statement

OCI_STMT_ALTER ALTER statement

OCI_STMT_BEGIN BEGIN... (PL/SQL)

OCI_STMT_DECLARE DECLARE... (PL/SQL)

--

signature
Kind regards

Norbert Debes

http://www.oradbpro.com

http://www.oradbpro.com

GSM: +49 177 6895186

Fax: +49 1212 536735037

SMTP: [email protected]