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....