Problem calling Oracle's stored procedure in ABAP ECC6

[former_member194650]

Hi.

We have the following Native SQL statement in R/3 Release 4.6C, that work's well:

EXEC SQL.

EXECUTE PROCEDURE

sap_distr_utils_pkg.get_info_cli_prc(

in :w_kunnr,

out :nome1) %_ERRCODE INTO :rc

ENDEXEC.

Now we are in an upgrade to SAP ECC 6.0 and the ABAP program d'ont compile.

The Error is:

Unable to interpret "%_ERRCODE". Possible causes: Incorrect spelling or comma error.

Any ideas? Any help will be appreciated.

Thanks & Regards,

Carlos

[former_member194650 · Accepted solution]

a®s,

Thanks for your reply.

I've changed but i get a dump:

DBIF_DSQL2_SQL_ERROR

CX_SY_NATIVE_SQL_ERROR

[former_member194669 · Accepted solution]

> 
> DBIF_DSQL2_SQL_ERROR  
> CX_SY_NATIVE_SQL_ERROR

sql_error is pointing to error in your sql statement. i am not sure you need to check the stored procedure input parameters, is number of input parameters are same in stored procedure? or the connectivity is there?

a®

[former_member194669]

Hi,

The addition %ERRCODE is exclusively designed for internal use. It is no longer available as of Release 6.10

please see the note 364707

May be you can change code this way

EXEC SQL.
EXECUTE PROCEDURE
sap_distr_utils_pkg.get_info_cli_prc(
in :w_kunnr,
out :nome1 )
ENDEXEC.
IF SY-SUBRC ne 0 OR nome1 ne 347.
    WRITE: / 'Wrong result for EXECUTE PROCEDURE:', nome1.
ENDIF.

a®