Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> execute immediate and cursor- example
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 - 05:32:15 CDT