Michael A Chase wrote: >>Is there a way I can prepare a statement handle for some SQL like >> >> insert into some_table values (:a, :b) >> >>and then find out what types the database is expecting for the two >>placeholders? I'm using DBD::Oracle.
>Placeholders are VARCHAR2 by default. If you know what columns you are >inserting into (and you should), you can use $dbh->column_info() to >find out the column types. Sorry, I gave the wrong example. In fact my query is just a select statement. I'd like to find out whether Oracle is expecting a given bind variable to be a datetime, an integer or whatever. -- Ed Avis <[EMAIL PROTECTED]>