Re: Perl DBI-Related Error - really in the weeds

Just some comments and questions.

You don't need the "install_driver" statement.
I believe it should be "Oracle" not "oracle" in the connect statement (see the DBD::Oracle docs).
"describe" is probably not a SQL statement (not everything that works in SQL*Plus works in OCI or DBD::Oracle).
How did you install DBI (and DBD::Oracle)?

Comment on Re: Perl DBI-Related Error - really in the weeds

Replies are listed 'Best First'.
Re^2: Perl DBI-Related Error - really in the weeds by o2bwise (Scribe) on Feb 23, 2006 at 00:56 UTC
Oh boy... Your questions are certainly demonstrating my ignorance. I tried to mimic code that I took from part of a perl script I wrote for mysql. I did not install DBI and don't know if DBD::Oracle is installed nor have I ever heard of it, nor did I even know it was required in order for my script to run. I am at work and will be away for a bit, but THANKS. You have certainly shed some light into my darkness. Tony	[reply]
Re^2: Perl DBI-Related Error - really in the weeds by o2bwise (Scribe) on Feb 23, 2006 at 00:59 UTC
By the way, describe does work. I tried it before using it.	[reply]
Re^3: Perl DBI-Related Error - really in the weeds by runrig (Abbot) on Feb 23, 2006 at 01:01 UTC
It worked in mysql or Oracle? (and how do you know it worked if you can't get it working?) Update: And some quick googling tells me that DESCRIBE is a SQLPlus command, but not valid SQL. You can maybe use the DBI table_info method (or column_info? I don't know, I've never used either one) or select from one of the Oracle _TABLES (*=DBA\|ALL\|USER) tables.	[reply]
Re^4: Perl DBI-Related Error - really in the weeds by o2bwise (Scribe) on Feb 23, 2006 at 01:02 UTC
It worked in oracle. I went into sqlplus from the server that has the oracle database and entered the sql command there.	[reply]
Re^3: Perl DBI-Related Error - really in the weeds by kwaping (Priest) on Feb 23, 2006 at 15:27 UTC
For the record, I just tested a describe statement using working copies of DBI and Oracle. The statement fails on execute with this error: `DBD::Oracle::st execute failed: ORA-00900: invalid SQL statement (DBD +ERROR: OCIStmtExecute) [for Statement "describe [schema.table removed + for security]"]` [download]	[reply] [d/l]