|
BEGIN
cur_hdl := dbms_sql.open_cursor; -- open cursor
p_str := 'SELECT '||p_pk2||' FROM '||p_bm||' WHERE ypbh in(select ypbh from '||P_EJDDB||' WHERE YPBH IN(SELECT YPBH FROM AJHD01 ))''';
dbms_sql.parse(cur_hdl,p_str,dbms_sql.native);
p_rows := dbms_sql.execute(cur_hdl); --execute
LOOP -- fetch a row
IF dbms_sql.fetch_rows(cur_hdl) > 0 then
该怎么将P_PK2的值传递给每个变量,因为 P_PK2是一个动态的变量,可能是(DW,YPBH,SYWD ) 、或者(DW,YPBH,TXBH,XH)这样变量的个数是不确定的,这里该如何写呀???
END LOOP;
dbms_sql.close_cursor(cur_hdl); -- close cursor
END; |
|