Native SQL -> Runtime Error: DBIF_DSQL2_SQL_ERROR (OCI returned error code)

Former Member — Fri, 23 Jul 2010 11:19:38 GMT

Hi,

I have sometimes a problem with a NATIVE SQL-Statement.

Runtime Error text:

Database error text........: "OCI returned error code -2."

Database error code........: "-2"

Triggering SQL statement...: "FETCH NEXT "

Internal call code.........: "DBDS/NEW DSQL"

Sometimes it works and sometimes we have this error.

Can anyone help me on this error?

Best Regards

André

Re: Native SQL -> Runtime Error: DBIF_DSQL2_SQL_ERROR (OCI returned error code)

Former Member — Mon, 25 Jul 2011 10:33:55 GMT

Hi !

also a my job that runs every day, gets the same error in the production system at least once a month ! and nobody could help me to find out why.

Regards

Graziano Cortese