Hi,
I am getting a dump on execution of a SQL statement, where the data is huge.
The error description...
Possible errors:
o The maximum size of an SQL statement has been exceeded.
o The statement contains too many input variables.
o The space needed for the input data exceeds the available memory.
The SQL Statement raising the error ...
SELECT * FROM z9ars_agreement
INTO CORRESPONDING FIELDS OF TABLE pp_z9p_generic_agreement
WHERE agreement IN r_agreement
AND customer = space
and orderbegindate le pp_validity_date "v003
and orderenddate ge pp_validity_date "v003
AND orderbegindate LE l_to_date "v003
AND orderenddate GE l_from_date. "v003
DESCRIBE TABLE pp_z9p_generic_agreement LINES g_line_count.
The data in the r_agreement is Huge causing the dump.
The Z program is calling a Function Module where this select statement is executed.
This FM is being used by lots of other programs.
Kindly let know how to rectify the Error.
Do let know if any other details are required.
Thanks in advance.
Regards,
Syed