Please Help ORA-06512 !

My Package : I'm passing in a number like 270318 to the procedure and = wish to get a number out like 9378324517.

AS

TYPE tani is TABLE of VARCHAR2(10)

INDEX BY BINARY_INTEGER; PROCEDURE el_web_pd3(sismas_in IN INTEGER,ani OUT tani);

END WEB_REPORTING_PAK; My Procedure:

AS

PROCEDURE el_web_pd3(sismas_in IN INTEGER, ani OUT tani) IS

CURSOR person_cur IS

SELECT ani

FROM el_commission

where sismas = sismas_in;

percount NUMBER DEFAULT 1;

person_cur_vals person_cur%ROWTYPE;

BEGIN OPEN person_cur;

LOOP FETCH person_cur into person_cur_vals;

exit when person_cur%NOTFOUND;

ani(percount) := person_cur_vals.ani;

percount := percount + 1;

END LOOP; CLOSE person_cur;

END el_web_pd3;

END el_web_pd3;

My call from ASP:

cmdTemp.CommandText = "web_reporting_pak.el_web_pd3(270318,{resultset = 2,ani})"

My Error:  

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC driver for Oracle][Oracle]ORA-06512: at line ORA-06512: = at line 1

/ElcotelWebReportsDev/Pd_Test.asp, line 14

I dont know why I'm getting the error. Any help would be appreciated ! --

Johnny L. Sloans Jr.,
MIS, CenturyTel Inc.
jsloans_at_cticallcenter.com Received on Fri Sep 24 1999 - 14:48:40 CDT