title: Why can't we use strong ref cursor with dynamic SQL Statement?
body: <p>I am trying to use a strong ref cur with dynamic sql statment but it is giving out an error,but when i use weak cursor it works,Please explain what is the reason and please
  forward me any link of oracle server architect containing matter  about how compilation and parsing is done in Oracle server. THIS is the error along with code.</p>
  
  <pre><code>ERROR at line 6:
  ORA-06550: line 6, column 7:
  PLS-00455: cursor 'EMP_REF_CUR' cannot be used in dynamic SQL OPEN statement
  ORA-06550: line 6, column 2:
  PL/SQL: Statement ignored
  
  declare
        type ref_cur_type IS REF CURSOR RETURN employees%ROWTYPE; --Creating a strong REF cursor,employees is a table
       emp_ref_cur ref_cur_type;
       emp_rec employees%ROWTYPE;
  BEGIN      
     OPEN emp_ref_cur FOR 'SELECT * FROM employees';
             LOOP
                     FETCH emp_ref_cur INTO emp_rec;
                     EXIT WHEN emp_ref_cur%NOTFOUND;
             END lOOP;       
  END;
  </code></pre>