Answered
Ref Cursor and type
Hi all
I finally got the Ref Cursor stored procedure working but am stuck on the following. I have this package body:
CREATE OR REPLACE PACKAGE BODY PACK_MYCURSOR AS
PROCEDURE REFCUR (
theuserid IN OUT users.user_id%type,
userfirstname OUT users_TableRows) IS
BEGIN
OPEN userfirstname FOR
select * from users
where user_id = theuserid
;
END REFCUR ;
END PACK_MYCURSOR ;
/
Now this is working fine, but I would need to have explisit fields in the select statement, like "select user_id from users", but when I do this then I get error messages of "expression is of wrong type". Anybody know how to solve this?
Thank you.
I finally got the Ref Cursor stored procedure working but am stuck on the following. I have this package body:
CREATE OR REPLACE PACKAGE BODY PACK_MYCURSOR AS
PROCEDURE REFCUR (
theuserid IN OUT users.user_id%type,
userfirstname OUT users_TableRows) IS
BEGIN
OPEN userfirstname FOR
select * from users
where user_id = theuserid
;
END REFCUR ;
END PACK_MYCURSOR ;
/
Now this is working fine, but I would need to have explisit fields in the select statement, like "select user_id from users", but when I do this then I get error messages of "expression is of wrong type". Anybody know how to solve this?
Thank you.
AdChoices