enhancement: DBD::Oracle and OCI_ATTR_STMT_TYPE

[Norbert Debes]

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) -- Kind regards Norbert Debes http://www.oradbpro.com GSM: +49 177 6895186 Fax:  +49 1212 536735037 SMTP: [EMAIL PROTECTED]