RE: :Oracle problems

Subject: RE: :Oracle problems

Subject: DBD::Oracle problems

All,



I am getting the following error while trying to use DBD::Oracle:



DBD::Oracle::st execute failed: ORA-00900: invalid SQL statement (DBD
ERROR: OCIStmtExecute) [for Statement "describe ALL_USERS"] at
../oracleTest.pl line 69.



I have tested the connection manually with sqlplus, and all is good there.
I have also run some select statements with the DBD::Oracle driver that
DID work. So all is good there.



HOWEVER what is wrong with this describe statement and why do I get the
error above???



my $sth = $dbh->prepare(qq{describe ALL_USERS});

$sth->execute;





A WORKING snippet is:

my $sth = $dbh->prepare(qq{select count(USERNAME) from ALL_USERS});



and happens to return 635 as the result as expected.



So I believe that I understand how to use the driver but there is
obviously something about the describe that is different.



I don't think "describe" is an SQL command...

Try " select column_name from ALL_TAB_COLUMNS
where table_name = 'ALL_USERS'"

jwm


Also see the DBI method "column_info"

jwm
.