This is a question for the DBI-Users mail list.
Tom
On Mon, May 07, 2001 at 05:32:29PM -0700, Shah, Deepak K wrote:
> 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.
>
--
Thomas A. Lowery
See DBI/FAQ http://tlowery.hypermart.net
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
