topic Re: Non-Catchable exception in Application Development and Automation Discussions

Non-Catchable exception

Madjid_Khanevadegi — Wed, 10 Jul 2019 14:50:11 GMT

Hello

how to handle Non-Catchable exception in abap

like "EXSQL_DSQL_DUPLICATE_CURSOR"

thank you

Re: Non-Catchable exception

matt — Wed, 10 Jul 2019 17:10:23 GMT

Make sure there are no duplicates before executing the code.

Re: Non-Catchable exception

Madjid_Khanevadegi — Thu, 11 Jul 2019 05:42:38 GMT

yes , i use only one cursor in my code

Re: Non-Catchable exception

matt — Thu, 11 Jul 2019 06:26:38 GMT

Duplicate records.

Re: Non-Catchable exception

Sandra_Rossi — Thu, 11 Jul 2019 06:44:42 GMT

Whatever the exception is, a "Non-Catchable exception" cannot be "handled". It just stops.

But maybe you can prevent the exception from happening... So you should tell us more about your code!

Re: Non-Catchable exception

Madjid_Khanevadegi — Thu, 11 Jul 2019 07:23:51 GMT

Hello Sandra

i now that this error may be occured for example when Fetch Next Cursor into work area ,does not match corresponding field of query with work area

Anyway i wants handle "non-catchable" exception in my abap code .

That is not possible

thanks

Re: Non-Catchable exception

Madjid_Khanevadegi — Thu, 11 Jul 2019 07:31:18 GMT

my query is not has duplicate record
the Short Text of error is "The specified cursor is already open."

but i do not have specify that the cursor is open or not

thanks

Re: Non-Catchable exception

matt — Thu, 11 Jul 2019 09:11:13 GMT

Oh yes, I see. I saw the word duplicate, but not the word cursor.

The advice remains - you need to make sure the error doesn't happen, rather than try to catch it. There is clearly a programming error - your trying to open a cursor that's the same as the one you've already got. The documentation says

The specified cursor is already open. An OPEN command command in Native SQL has a specified cursor, which the cursor administration knows is already open.

Rather than Native SQL, use the CL_SQL_... classes. Then you'll get catchable errors.

Re: Non-Catchable exception

Madjid_Khanevadegi — Thu, 11 Jul 2019 10:24:35 GMT

Thank you Matthew Billingham

in Native SQL ,before open my cursor how to define its open , for close it .

if the cursor is not close or program encounter with short dump , the cursor is open in background and Apparently its maintain in sap system cash.

Re: Non-Catchable exception

matt — Thu, 11 Jul 2019 11:36:38 GMT

As I said:

Rather than Native SQL, use the CL_SQL_... classes. Then you'll get catchable errors.