ASP + PL\SQL problems

From: <jimi_xyz_at_hotmail.com>
Date: 27 Jul 2005 12:37:44 -0700
Message-ID: <1122493064.091153.133570@g44g2000cwa.googlegroups.com>

I am trying to pass an array from ASP into the pl\sql api.. which then is put into a variable of type table, but i keep getting an error. Any ideas here is my code.

ASP..... sqlproc = "SUBMITQUERY_API.query"

sqlparams = array( "word_to_search", searchstring, ORAPARM_INPUT,

   ORATYPE_VARCHAR2, _
"location_array", loc, ORAPARM_INPUT, ORATYPE_FARRAY, _
"cv", null, ORAPARM_OUTPUT, ORATYPE_CURSOR, _

   		"out_error_code",    	0,    		ORAPARM_OUTPUT,   ORATYPE_NUMBER, _
   		"out_error_message",    "",    		ORAPARM_OUTPUT,

ORATYPE_VARCHAR2 ) sqlretvals = APIIntFace( sqlproc, gobjConn, sqlparams, true )

pl\sql....

CREATE OR REPLACE PACKAGE SUBMITQUERY_API AS
type curtype is ref cursor;
type charArray is table of VARCHAR2(24) index by binary_integer;

PROCEDURE query(

                        word_to_search IN VARCHAR2,
						location_array IN charArray,
                        cv IN OUT curtype,
                        out_error_code OUT NUMBER,
                        out_error_message OUT VARCHAR2);

END;
/
show errors

CREATE OR REPLACE PACKAGE BODY SUBMITQUERY_API AS CONST_PACKAGENAME CONSTANT VARCHAR2(15) := 'submitquery_api';

---

PROCEDURE query(

                        word_to_search IN VARCHAR2,
						location_array IN charArray,
                        cv IN OUT curtype,
                        out_error_code OUT NUMBER,
                        out_error_message OUT VARCHAR2)

IS
BEGIN Received on Wed Jul 27 2005 - 14:37:44 CDT