execute immediate and cursor example

From: mariusz <on_at_wp.pl>
Date: Tue, 23 Jul 2002 12:33:03 +0200
Message-ID: <ahjbh6$8o3$1_at_news.tpi.pl>

create or replace function funkcja (pName in varchar2,psome_table in varchar2) return integer is
  Result integer;
  TYPE EmpName IS RECORD (name VARCHAR2(100));   TYPE cur_type IS REF CURSOR RETURN EmpName;   curs cur_type;
begin
  execute immediate 'OPEN curs for SELECT '||pname||' FROM'||psome_table;-- this is Error!!!
 return(0);
end funkcja;
-- I want to write sql statement like this 'select sth,'||psth||'from '||ptable_name but in cursor!!!
How can I do that? Received on Tue Jul 23 2002 - 12:33:03 CEST