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.



Thanks

Chris Hood

Relevant Pages

  • Re: SQLPLUS driver
    ... I am trying to find articles/resources about what kind of database driver ... To connect to a database using sqlplus you need a full client (all ... Eventually sqlplus uses OCI (Oracle Call Interface), ...
    (comp.databases.oracle.server)
  • RE: :Oracle problems
    ... I have tested the connection manually with sqlplus, ... So I believe that I understand how to use the driver but there is ... Prev by Date: ...
    (perl.beginners)
  • ME update to XP problem
    ... to update a driver. ... when I tried to load XP again - it still won't work. ... Prev by Date: ...
    (microsoft.public.windowsxp.newusers)
  • Re: Boxes for 6x9
    ... >> data & reference. ... >> Can you please let me know what to proceed with, since 3 cuft space per ... >> driver in not available. ... Prev by Date: ...
    (rec.audio.car)
  • Re: condivisione stampante con windows via router-wifi
    ... devo installare i driver sull'ibook della stamante remota? ... Prev by Date: ...
    (it.comp.macintosh)