Dear All,

I want to incooperate a Oracle stored procedure which accept one VARCHAR2 parameter and return TABLETYPE data as the second parameter (return parameter) in to my ASP application.

Can anybody please tell me how access the TABLE type return type data parameter in ASP page ??.

Would appriciate if you could send me some sample code.

Thanks,
Chamil.

My Procedure as below.
----------------------------------------------------------------------------
CREATE OR REPLACE PACKAGE WFDEV_TEST IS

TYPE wfdevin_type IS TABLE OF WFDEVELOPERS%ROWTYPE INDEX BY BINARY_INTEGER;
wfdevout_type wfdevin_type;

PROCEDURE WFDEVELOPERS_TEST (vc_staffid IN VARCHAR2 ,wfdevout_type OUT wfdevin_type);

END WFDEV_TEST;

CREATE OR REPLACE PACKAGE BODY WFDEV_TEST IS

PROCEDURE WFDEVELOPERS_TEST (vc_staffid IN VARCHAR2 ,wfdevout_type OUT wfdevin_type) IS
CURSOR c1 IS SELECT * FROM wfdevelopers
WHERE staff_id = vc_staffid;
BEGIN
wfdevout_type.DELETE;
FOR c2 IN c1 LOOP
wfdevout_type(c1%ROWCOUNT).staff_id := c2.staff_id;
wfdevout_type(c1%ROWCOUNT).process_id := c2.process_id;
END LOOP;
END;

END WFDEV_TEST;