topic Re: itab exception handling in Application Development and Automation Discussions

itab exception handling

Former Member — Thu, 05 Oct 2006 08:35:24 GMT

Hi all,

to avoid short dumps due to too large itabs, I wanted to catch an exception. (Consider: The itab size depends on user input). Unfortunately, the following coding doesn’t work:


TRY.
  SELECT *
    FROM dbase
    INTO itab
    WHERE ….

CATCH cx… INTO ref_exc

ENDTRY.

In case of too large itab, the system doesn’t execute the catch command. Has anybody an idea how to avoid a short dump due to few buffers available?

Regards,

Thomas

Re: itab exception handling

Former Member — Thu, 05 Oct 2006 08:39:25 GMT

Why don't you create the wright variable?

DATA: MY_WA TYPE REF TO DATA.

FIELD-SYMBOLS: <WA> TYPE ANY.

CREATE OBJECT MY_WA TYPE (DBASE).

ASSIGN MY_WA->* TO <WA>.

SELECT *

FROM dbase

INTO <WA>

WHERE ….

Max

Re: itab exception handling

Former Member — Thu, 05 Oct 2006 08:42:08 GMT

As you said that itab size depends on user input why dont u use the variation of select statement as to fetch records up to x rows only.

Re: itab exception handling

Former Member — Thu, 05 Oct 2006 13:19:58 GMT

Hi,

I just want to catch the system exception (dump: tsv_tnew_page_alloc_failled) nothing else. However, I didn’t find a predefined exception class like for instance cx_sy_zerodivide. Any ideas ?

Regards

Thomas

Re: itab exception handling

Former Member — Thu, 05 Oct 2006 13:56:39 GMT

Use the PACKAGE SIZE option of the SELECT statement.

Rob

Re: itab exception handling

Former Member — Thu, 05 Oct 2006 14:42:58 GMT

Try if you can catch the particular exception class.

CX_SY_SQL_ERROR

Regards

Anurag

Re: itab exception handling

Former Member — Fri, 06 Oct 2006 07:22:44 GMT

Hi,

cx_sy_sql_error doesn't work.

I think I'll be working with the package size statement.

Thanks

Thomas