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
