Cursor parameter or PL/SQL variable?

Hello,

I didn't find any discussions for advantages or disadvantage when calling a cursor with a cursor parameter or query in cursor refers to other PL/SQL variables within its scope.

First case when cursor is calling with a parameter... PROCEDURE my_procedure(p_parameter IN NUMBER := NULL) IS
CURSOR c_my_cursor(c_parameter NUMBER)
IS
  SELECT name FROM my_table
    WHERE id = c_parameter;

BEGIN
  FOR l_object IN c_my_cursor(p_parameter) LOOP
...

  END LOOP; END; Second case when query in cursor refers to procedure parameter... PROCEDURE my_procedure(p_parameter IN NUMBER := NULL) IS
CURSOR c_my_cursor
IS
  SELECT name FROM my_table
    WHERE id = p_parameter;

BEGIN
  FOR l_object IN c_my_cursor LOOP
...

  END LOOP; END; Thamks in advance.

Erika Received on Mon Aug 28 2000 - 04:41:39 CDT