DevOps, CI/CD and Automation

I am trying to help a developer solve a problem. We are converting her DB from 8i to 9i and a call to a stored procedure is returning an ORA-1044 error.

We are using MS Driver for Oracle 2.573.4403.00 on NT, with VB6.

I am pretty sure that the procedure is not actually executing. The error is being retuned from the call adoRptRs.open (an MS supplied object which is a part of ActiveX Data Objects).

The actual text in the error is [Microsoft][ODBC Driver for Oracle][Oracle]ORA-01044: size 4836000 of buffer bound to variable exceeds maximuim 4194304.

Any guidance would be appreciated.

TIA,

Mark

Here is the oerr for ORA-1044:

01044, 00000, "size %s of buffer bound to variable exceeds maximum %s"
// *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 buffer size.



The is the package header:

CREATE OR REPLACE PACKAGE ANMSAPP.pkg_t_reports
AS
TYPE t_rpt_record_txt IS TABLE of VARCHAR(78)
INDEX BY BINARY_INTEGER;
TYPE t_more_rec_ind IS TABLE of NUMBER(9)
INDEX BY BINARY_INTEGER;
TYPE t_curcounter IS TABLE of NUMBER(9)
INDEX BY BINARY_INTEGER;
PROCEDURE sel_reports_bankone_m_001
(
v_fi_group_id IN NUMBER,
v_bgn_dt IN CHAR,
v_end_dt IN CHAR,
i_start_nbr IN NUMBER,
i_curcounter IN NUMBER,
rpt_record_txt OUT t_rpt_record_txt,
o_more_rec_ind OUT t_more_rec_ind,
o_curcounter OUT t_curcounter
);
END pkg_t_reports;

Here is the procedure declare:

CREATE OR REPLACE PACKAGE BODY ANMSAPP.pkg_t_reports
AS
PROCEDURE sel_reports_bankone_m_001
(
v_fi_group_id IN NUMBER,
v_bgn_dt IN CHAR,
v_end_dt IN CHAR,
i_start_nbr IN NUMBER,
i_curcounter in NUMBER,
rpt_record_txt OUT t_rpt_record_txt,
o_more_rec_ind OUT t_more_rec_ind,
o_curcounter OUT t_curcounter
)
IS