Skip to Content
0
Former Member
Feb 24, 2009 at 10:59 AM

DBIF_DSQL2_OBJ_UNKNOWN

834 Views

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