execute immediate for cursor
From: mariusz <on_at_wp.pl>
Date: Tue, 23 Jul 2002 10:51:54 +0200
Message-ID: <ahj5jv$n5u$1_at_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!!
Date: Tue, 23 Jul 2002 10:51:54 +0200
Message-ID: <ahj5jv$n5u$1_at_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 - 10:51:54 CEST