Hi Experts,
While I was trying to create a connection from SAP to Oracle server via t-code dbco, I had encountered a runtime error : DBIF_DSQL2_OBJ_UNKNOWN
Exception : CX_SY_NATIVE_SQL_ERROR
I also visited the forums having subject cx_sy_native_sql_error but i didn't find out the solution of mine problem.
Here i m giving u some details abt connection and program
DBconnection Name : mycon
DBMS : ORA
username : KML
password : ***
Connection info : Oracle
Permanent = Checked
Program :
REPORT ZDATAFRMORA_KK .
DATA: c TYPE cursor.
data: begin of ithead occurs 0,
PRODUCT_CODE(9),
MIN_DATE TYPE DATE,
ITEM_CODE(9),
ACCEPT_QTY(20),
PRODUCT_NAME(70),
VEND_CODE(4),
end of ithead.
EXEC SQL.
CONNECT TO 'MYCON' as 'k'
ENDEXEC.
EXEC SQL.
SET CONNECTION 'k'
ENDEXEC.
EXEC SQL.
open c for
SELECT * from ADJ_TEMP
ENDEXEC.
DO.
EXEC SQL.
FETCH NEXT c INTO :ithead
ENDEXEC.
append ithead.
IF sy-subrc ne 0.
EXIT.
ENDIF.
ENDDO.
EXEC SQL.
CLOSE c
ENDEXEC.
EXEC SQL.
DISCONNECT :'MYCON'
ENDEXEC.
loop at ithead.
WRITE: / ithead-PRODUCT_CODE, ithead-ITEM_CODE.
endlooP.
end of report **************
When i execute the above report than its ternimate in between and above error has been occured
I also checked table ADJ_TEMP in oracle server.
Please suggest and help me
Thanks in Advance.
Krishan Kumar