topic Re: exception DBIF_DSQL2_INVALID_CURSOR,CX_SY_NATIVE_SQL_ERROR syntax error in Application Development and Automation Discussions

exception DBIF_DSQL2_INVALID_CURSOR,CX_SY_NATIVE_SQL_ERROR syntax error

Former Member — Fri, 05 Feb 2010 08:27:02 GMT

Hi to everyone,

While I was trying to catch some data from Siebel, I've received this dump error.

I know the problem was trying to make a filter on the where condition on the EXEC ---> ENDEXEC statement. (I've tried it without this filter and it runs correctly).

I need to filter by the field last_upd that has a structure (MM/DD/YYYY HH24:MI:SS) but I only want to filter by date, ignoring time.

I'll trying like this:

EXEC SQL.

open c for

select

....

from siebel.s_srv_req_x table_1a,

where

.....

table_1a.last_upd like To_date('02/02/2010','DD/MM/YYYY')

ENDEXEC.

When I execute, it dumps.

Thanks to everyone.

Wladimir.

Re: exception DBIF_DSQL2_INVALID_CURSOR,CX_SY_NATIVE_SQL_ERROR syntax error

Former Member — Fri, 05 Feb 2010 09:56:22 GMT

Anyone?

Edited by: Wlade22 on Feb 8, 2010 4:22 PM

Edited by: Wlade22 on Feb 10, 2010 6:56 PM

Re: exception DBIF_DSQL2_INVALID_CURSOR,CX_SY_NATIVE_SQL_ERROR syntax error

Clemenss — Wed, 10 Feb 2010 18:32:35 GMT

Never tried native SQL, try

WHERE Todate LIKE '02/02/2010 __:__:__'

Regards,

Clemens

Re: exception DBIF_DSQL2_INVALID_CURSOR,CX_SY_NATIVE_SQL_ERROR syntax error

sergey_korolev — Wed, 10 Feb 2010 20:16:46 GMT

I remember something like this, when doing native SQL for ORACLE, and that time the reason was statement ending symbols (semicolon), maybe this is the case? Try semicolon before ENDEXEC.