Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> PROCEDURE WITH CURSOR PROBLEM

PROCEDURE WITH CURSOR PROBLEM

From: Guilherme <guilhermecsanches_at_gmail.com>
Date: Sat, 16 Jun 2007 15:32:25 -0700
Message-ID: <1182033145.767132.240730@q69g2000hsb.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US