exception DBIF_DSQL2_INVALID_CURSOR,CX_SY_NATIVE_SQL_ERROR syntax error

[Former Member]

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.

[Former Member]

Anyone?

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

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

[Clemenss]

Never tried native SQL, try

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

Regards,

Clemens

[sergey_korolev]

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.