Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> PROCEDURE WITH CURSOR PROBLEM
Hi,
Iīm trying to create a procedure, then returns a dynamic cursor, like this:
CREATE PROCEDURE p_name(
ret OUT SYS_REFCURSOR,
p1 IN NUMERIC
)
IS
BEGIN
DECLARE sql VARCHAR
sql := 'select * from table';
IF p1 IS NOT NULL THEN
sql := sql||'WHERE id = '||p1;
END IF
OPEN ret FOR sql;
END;
but itīs not working, I donīt have a error when I create, but when I
call this procedure doesn't work.
What can I do? Please Help me...
Received on Sat Jun 16 2007 - 17:32:25 CDT