The CREATE OR REPLACE function SCOTT. INFO
(TAB in varchar2, dept_no in number)
Return t_emp pipelined
Is
V r_emp;
Type t_cur_c_sif is ref cursor;
C_sif t_cur_c_sif;
Tabl dept % rowtype;
TAB is passed in the name of the table, I want to declare tabl with dynamic method statement, such as:
Tabl TAB % rowtype; But such an error

CodePudding user response:

Actually t_emp and r_emp are external statement,

You directly in the external use dynamic SQL is not quite good?

CodePudding user response:

There is no such SAO operation well