topic Re: Return code for EXECUTE PROCEDURE (native SQL) in Application Development and Automation Discussions

Return code for EXECUTE PROCEDURE (native SQL)

Former Member — Tue, 18 Apr 2006 12:30:32 GMT

Hi Experts,

I've seen in the Note 364707 that the field %_ERRCODE is no longer supported since WAS 6.10 for stored procedures like this:

EXEC SQL.
  EXECUTE PROCEDURE proc [(parameter list)] %_ERRCODE INTO :rc
ENDEXEC.

So an Upgrade to WAS 7.00 gives this programms an error.

Has anybody an idea for an alternative?

Regards,

Stefan

LucianoBentiveg — Tue, 18 Apr 2006 14:43:38 GMT

We are using retrieving error information from stored procedure and using sy-subrc. Example:

EXEC SQL.

execute procedure get_account_info@STEALTH

( in :ACCOUNT,

out :CUST_ID,

out :CUST_NAME,

out :ACC_ADDRESS_STREET,

out :ACC_ADDRESS_NUMBER,

out :ACC_SUBURB,

out :ACC_ADDRESS_CITY,

out :ACC_ADDRESS_FLAT,

out :ACC_ADDRESS_FLOOR,

out :ERRNO,

out :ERRMSG )

ENDEXEC.

IF sy-subrc <> 0.

RAISE err.

ENDIF.

Former Member — Thu, 06 Sep 2007 14:53:35 GMT

Hello Peluka,

i have seen you have worked with 'execute procedure'.

I want to execute a procedure with two Parameters and one structure. Example:

EXECUTE PROCEDURE test.p_getdata ( in :i_ls_nr , in :vdatum , out :vtest ).

vtest has the simple structure with field lieferscheinnr (char25).

When i execute the procedure, i get the error <b>wrong number or types of arguments in call</b>.

Do you know, whether execute procedure with structures is not possible?

Thank you in advance.