CATCH EXCEPTION DBIF_DSQL2_SQL_ERROR

[Former Member]

Hello all,

I'm querying an external System via DBLINK.

In some cases this results in a dump (e.g. when there are no rows returned).

So i tried to catch the RUNTIME ERROR because i want to continue processing.

I tried the following code but for some reason it continues dumping.

All suggestions welcome!

Thomas

CATCH SYSTEM-EXCEPTIONS OTHERS = 1.

exec sql.

execute procedure p_getidbyname@ZWINCASH

(IN :mg, IN :'Merchand.', IN :'Y', OUT :mgid )

ENDEXEC.

endcatch.

if sy-subrc = 1.

write:/ 'Da ist was falch gelaufen'.

endif.

[RichHeilman · Accepted solution]

You do not appear to be trying to catch a specific system exception. The exception DBIF_DSQL2.... is not a catchable system exception.

Regards,

Rich Heilman

[Former Member · Accepted solution]

Hello Rich,

Thank you for your response.

So it is true that there are uncatchable exceptions.

I just did'nt want to believe it.

If anybody out there knows a way to prevent a dump on exceptions that are not stated under "catchable RUNTIME ERROR" please tell me!

[RichHeilman · Accepted solution]

In these cases you must prevent them from happening, not sure how you would go about it with your particular case(using native SQL).

Regards,

Rich Heilman

[Former Member]

Have you tried to incorporate the error capture in your external db procedure and pass the resultant error message as a parameter or a normal raise exception?