There are properties of the statement handle that you can use to get this info. Try something like this (for select statements only) after you execute the sql statement.
for ($cnt = 0; $cnt < $sth->{NUM_OF_FIELDS}; $cnt++) { print "$sth->{NAME}->[$cnt]\n"; } See the section on Statement Handle Objects in Appendix A of Programming the Perl DBI for more info. -Josh -----Original Message----- From: Georg Botorog [mailto:georg@;huggle.de] Sent: Friday, November 01, 2002 8:58 AM To: [EMAIL PROTECTED] Subject: OCI Stmt Info Importance: Low Hi, I am using DBI and DBD::Oracle. Is there any possibility to get the names of the bind variables back from OCI, such as returned by OCIStmtGetBindInfo()? The background is: I get a statement (defined elswhere) where the placeholders for the bind variables have the syntax ":name" (not "?") together with the necessary values. To bind the variables, I need to know their names (binding by position does not work here). Of course, I could parse the statement, and get the variable names. However, OCI has this information already, thus it would be silly not to use it. So my question is: does DBI, DBD, or any other package pass this information from OCI? Thanks, G. Botorog