Skip to Content
0
Former Member
Feb 25, 2011 at 06:40 PM

Error in Native SQL..

691 Views

Hello,

I am getting the below error while executing Native SQL statements.

Runtime Errors DBIF_DSQL2_SQL_ERROR

Except. CX_SY_NATIVE_SQL_ERROR

Short text

An SQL error occurred when executing Native SQL.

What happened?

The error 903 occurred in the current database connection "XXXXX".

******************************************************************************************************

Below is the code which we are working on..

EXEC SQL.

connect to :'XXXXX'----


>>Logical Connection name.

ENDEXEC.

EXEC SQL.

OPEN s_cursor FOR SELECT (S_S_IF-T_FIELDS)

FROM SAP_BW_FP_EXTRACT_VIEW.----


>>Oracle table/view name

ENDEXEC.

EXEC SQL.

FETCH NEXT s_cursor----


>>Getting Error at this line.

INTO :wa_et_data-FACT_TYPE_CODE,

:wa_et_data-FISCAL_YEAR_PERI,

:wa_et_data-PROD_FPC_ID,

:wa_et_data-GEO_ID,

:wa_et_data-LEGAL_ENT_ID,

:wa_et_data-PROFT_CTR_ID,

:wa_et_data-COMP_VOL_STAT_UN

ENDEXEC.

EXEC SQL.

CLOSE S_CURSOR.

ENDEXEC.

Any ideas where I am making a mistake, is it a syntax issue, or is it a Authorization issue, or something else..Please help..

Your Inputs will be appreciated....