Hi
I'm working with 2 stored procedures written by someone else. My Oracle is "adequate" for the job I'm doing but this is stretching me a bit.
I have an application which calls these stored procedures and processes the data. One is happy with 35 rows returned, the other craps out at 7. Unfortunately we need that 7 to work!
So, here's the header for my SP...
they're both identical!
We have out batch sizes etc, and they're both right. The code catching them is identical too - it's just IN parameeters and the inside the SP that differs. They use cursors and do some intensive processing but I'd have thought that wouldn't matter.
Any ideas?
I'm working with 2 stored procedures written by someone else. My Oracle is "adequate" for the job I'm doing but this is stretching me a bit.
I have an application which calls these stored procedures and processes the data. One is happy with 35 rows returned, the other craps out at 7. Unfortunately we need that 7 to work!
So, here's the header for my SP...
Code:
CREATE OR REPLACE PACKAGE ctmsp_get_cust_alerts_pkg AS
TYPE swId_table_type is table of NW_ALERTS.nwAlertsId%TYPE
index by binary_integer;
TYPE nwSeverity_table_type is table of NW_ALERTS.nwSeverity%TYPE
index by binary_integer;
TYPE swObjectType_table_type is table of NW_ALERTS.swObjectType%TYPE
index by binary_integer;
TYPE nwNote_table_type is table of NW_ALERTS.nwNote%TYPE
index by binary_integer;
they're both identical!
We have out batch sizes etc, and they're both right. The code catching them is identical too - it's just IN parameeters and the inside the SP that differs. They use cursors and do some intensive processing but I'd have thought that wouldn't matter.
Any ideas?