Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> execute immediate for cursor

execute immediate for cursor

From: mariusz <on_at_wp.pl>
Date: Tue, 23 Jul 2002 10:57:01 +0200
Message-ID: <ahj5ti$37i$1@news.tpi.pl> 





Hi,


Id' like to make a cursor:


cursor (ptable_name in varchar2) cu  is select * from  ptable_name; --
Error!!


I know that if I whant to do that in simple sql statemant, I can use:
execute immediate:


 execute immediate 'select * from '||ptable_name;
But, How to use it in cursor?


Thanks very much for your help!!



Mariusz G.
Received on Tue Jul 23 2002 - 03:57:01 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US