Error ORA-01044 after migration Oracle-DB 8.i to Oracle-DB 9.i

Hello

To invoke a stored procedure call using the sytax

"{call <package-name>.<proc-or-func>;

(....,{resultset<max-record-requested, <formal-array-param_1>,; <formal-array-param_2>, ......,<formal-array-param_n>}.....)}"

in an Oracle 8.i environment, was executed properly. The same method leeds in an Oracle 9.i environment to the error

"ORA-01044 size string of buffer bound to variable exceeds maximum string"

The Oracle Documentation says:
Error-Cause:
An attempt was made to bind a buffer whose total size would exceed the maximum size allowed.
Total array size for arrays is calculated as:

(element_size)*(number of elements)
Action:
Reduce the buffer size.

After reduction of the "number of elements" (here
"max-record-requested") the error-message doesn't occur any longer.

Now my questios are:

Is it possible to enlarge the "size of maximum 					string"?
Is this size configured by a parameter in the 					Oracle-Initial-Settings?

Thanks a lot in advance Received on Thu Mar 04 2004 - 09:01:22 CST