Declare Cursor in PL/SQL
s331246Dec 22 2006 — edited Dec 22 2006HI ALL,
Is it possiable declare inside of Procedure body?
Example:
BEGIN
IF test = 1 then
Declare CursorA.....where num =1;
ElSIF test = 2 then
Declare CursorA....where num=2;
ELSE
Declare CursorA....where num=3;
END;