code_junkie

PLS-00306 error on call to cursor

Nov 10th, 2011
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. CURSOR columnNames (inTableName IN VARCHAR2) IS
  2. SELECT COLUMN_NAME FROM USER_TAB_COLUMNS WHERE TABLE_NAME = inTableName;
  3. /* Removed for brevity */
  4. OPEN columnNames('TEMP');
  5.  
  6. FOR columnName IN columnNames LOOP
  7.  
  8. FOR columnName IN columnNames LOOP
  9.  
  10. create or replace procedure so_test_procedure as
  11. CURSOR columnNames (inTableName IN VARCHAR2) IS
  12. SELECT COLUMN_NAME FROM USER_TAB_COLUMNS WHERE TABLE_NAME = inTableName;
  13. BEGIN
  14. OPEN columnNames('TEMP');
  15. CLOSE columnNames;
  16. END;
  17.  
  18. procedure so_test_procedure Compiled.
  19. execute so_test_procedure();
  20.  
  21. anonymous block completed
Add Comment
Please, Sign In to add comment