ASP n PL/SQL [message #37784] |
Thu, 28 February 2002 02:28 |
Jules
Messages: 4 Registered: February 2002
|
Junior Member |
|
|
Hi,
maybe this is the wrong forum,but maybe some of you have already try those..
i tried to connect my pl/sql code to asp
but it always fail.. it said that.. something like :
Incomplete parameter..
i got the source from :
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q255043
http://www.learnasp.com/learn/FAQOraclestoredproc.asp
http://www.learnasp.com/learn/oraclerecordsetsfromsp.asp
i wonder.. if the error is in my pl/sql script ...
but when i create the package .. it's created without compilation error..
and here's my pl/sql script :
CREATE OR REPLACE PACKAGE GetRecords AS
TYPE t_cursor IS REF CURSOR ;
Procedure OpenCursor (io_cursor IN OUT t_cursor,stmt in varchar);
END GetRecords;
/
CREATE OR REPLACE PACKAGE BODY GetRecords AS
Procedure OpenCursor (io_cursor IN OUT t_cursor, stmt in varchar)
IS
v_cursor t_cursor;
BEGIN
OPEN v_cursor FOR stmt;
io_cursor := v_cursor;
END OpenCursor;
END GetRecords;
/
Please help me...
|
|
|
|