Skip to content
This repository has been archived by the owner on Feb 18, 2021. It is now read-only.

Does not support opening cursor with paramters #15

Open
mmh222 opened this issue Mar 28, 2013 · 0 comments
Open

Does not support opening cursor with paramters #15

mmh222 opened this issue Mar 28, 2013 · 0 comments

Comments

@mmh222
Copy link

mmh222 commented Mar 28, 2013

Following code block errors out

    CREATE OR REPLACE PACKAGE BODY abc
    IS
       CURSOR cur_rows (num_rows NUMBER)
       IS
          SELECT tname
        FROM tab
           WHERE ROWNUM < num_rows;

       PROCEDURE x
       IS
          y   VARCHAR2 (100);
       BEGIN
          OPEN cur_rows (5);

          LOOP
         FETCH cur_rows
          INTO y;

         EXIT WHEN cur_rows%NOTFOUND;
         DBMS_OUTPUT.put_line (y);
          END LOOP;
       END x;
    END abc;
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant