On 06/13/2005 02:56 AM, Avis, Ed said:
Michael A Chase wrote:
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.
The original example may have been wrong, but the advice still stands.
You can control the type of each placeholder. To decide what type you
want it to be, you have to know what column it is interacting with.
--
Mac :})
** I usually forward private questions to the appropriate mail list. **
Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
