Dear All,
I have an oracle package with a procedure in it.
From SQL prompt i execute the package like this.

SQL>var rc refcursor;
SQL>exec pck_concurrent.test(:rc);
SQL>print rc;

This will print the recordset in the SQL*Plus. However how do I call this procedure from an ASP page.
Can someone explain this in a series of steps?

Thanks in advance
qAnand

--Below is the package body
CREATE OR REPLACE PACKAGE BODY PCK_CONCURRENT AS
PROCEDURE TEST(P_RECORDSET OUT empcur)
IS
BEGIN
OPEN P_RECORDSET FOR
SELECT a.f1, a.f2, a.f3 FROM A
END TEST;
END PCK_CONCURRENT;
/