Re: ORA-00900: invalid SQL statement when using Perl DBI::Oracle module
From: Simon Mosley <sjmosley_at_btinternet.com>
Date: 2000/06/27
Message-ID: <8jb6g2$6bd$1_at_uranium.btinternet.com>#1/1
Date: 2000/06/27
Message-ID: <8jb6g2$6bd$1_at_uranium.btinternet.com>#1/1
Try selecting from the user_source table instead
P. Larsen wrote in message ...
>
>"Panos Kavalagios" <P.Kavalagios_at_hydro.ntua.gr> wrote in message
>news:393611B2.85658DDB_at_hydro.ntua.gr...
>> Hello,
>>
>> In my perl script, I have written the following:
>>
>> [ successful connection to the database precedes ]
>>
>> $sth=$dbh->prepare("describe mytablename");
>
>describe is NOT a SQL command. It's a SQL*Plus command.
>
>--
> P. Larsen
>
>
>
>
Received on Tue Jun 27 2000 - 00:00:00 CEST