Error EXEC SQL

Former Member — Tue, 28 Nov 2006 11:46:19 GMT

hello people,

I'm using the connection DBCOMM to connect a external BD, using this connection:

EXEC SQL.

SET CONNECTION :vg_con_name

ENDEXEC.

IF NOT sy-subrc IS INITIAL.

EXEC SQL.

CONNECT TO :vg_con_name

ENDEXEC.

ENDIF.

I verified the connection and before i maked a select in the table EKKO

kind of this:

EXEC SQL.

SELECT EBELN

FROM EKKO

INTO :P_EBELN

WHERE EBELN = :W_EBELN

ENDEXEC.

sometimes i lost the connection, but here in the project I use the version of R/3, 4.6c and don't have the command TRY to catch the problem.

The Dump is:

DBIF_DSQL2_SQL_ERROR

"ORA-03113: end-of-file on communication channel#"

anyone here can help me,

waiting

Wille

Re: Error EXEC SQL

Former Member — Tue, 28 Nov 2006 13:21:48 GMT

HI,

•Cause: There is an SQL error during execution of a Native SQL command.

Runtime Error: DBIF_DSQL2_SQL_ERROR

•If you want to select into a work area in a SELECT statement, and not into a list of host variables, the host variable must be a structure. If you cannot determine statically (at compilation time) whether the target area is a structure at runtime, then there is a runtime error, depending on the database system. Or only the first selected column is placed into the target area. In this case, one can be certain, using INTO STRUCTURE (instead of only INTO), that at runtime a structure really is available as target area.

•Please the connection which you have specified is existing in the DBCON TABLE.

Regards

Anitha

topic Re: Error EXEC SQL in Application Development and Automation Discussions

Error EXEC SQL

Re: Error EXEC SQL