> -----Original Message-----
> From: Shah, Deepak K [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 10:32 AM
> To: '[EMAIL PROTECTED]'
> Subject: database query fails when run with Perl
>
>
> Hello,
>
> We are running a query against an Oracle database using Perl.
> This query has
> a procedure that returns a random number which is used by the query.
> The query looks like : select a,b from c where d=GET_RANDOM_NUMBER
>
> GET_RANDOM_NUMBER is an oracle procedure here which returns a
> random number
>
> When we run this query directly against the database using
> sqlplus, the
> query works fine and givs appropriate results. However, when
> we fire the
> same query using a Perl program, it returns the following errors :
> DBD::Oracle::st execute failed: ORA-00920: invalid relational
> operator (DBD
> ERROR: OCIStmtExecute) at orasim.pl line 741.
> DBD::Oracle::st execute failed: ORA-00936: missing expression
> (DBD ERROR:
> OCIStmtExecute) at orasim.pl line 741.
>
> The same Perl program executes all other queries with error
> that do not call
> the procedure as part of the sql statement.
>
> Pls help.
>
> thanx,
> deepak
>
>
>
>
>
>
>
__________________________________________________________________________
Please Note :
Only the intended recipient is authorised to access or use this e-mail. If
you are not the intended recipient,
please delete this e-mail and notify the sender immediately. The contents
of this e-mail are the writer's
opinion and are not necessarily endorsed by the Gunz Companies unless
expressly stated.
We use virus scanning software but exclude all liability for viruses or
similar in any attachment.
