Re: 求救!!! 一个oracle的问题! 在procedure中所涉及的表名可以用变量从参数中传入吗# Database - 数据库
j*s
1 楼
U have to use DBMS_SQL package to solve this problem.
Should be something like this:
src_cur := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(src_cur,
'SELECT name, dot FROM ' || tbname ||
' WHERE dot = :ddot', DBMS_SQL);
DBMS_SQL.BIND_VARIABLE(src_cur, ':ddot', ddot);
DBMS_SQL.DEFINE_COLUMN(src_cur, 1, name);
DBMS_SQL.DEFINE_COLUMN(src_cur, 2, dot);
blah, blah, blah..., refer to the Developer Guide bah.
Should be something like this:
src_cur := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(src_cur,
'SELECT name, dot FROM ' || tbname ||
' WHERE dot = :ddot', DBMS_SQL);
DBMS_SQL.BIND_VARIABLE(src_cur, ':ddot', ddot);
DBMS_SQL.DEFINE_COLUMN(src_cur, 1, name);
DBMS_SQL.DEFINE_COLUMN(src_cur, 2, dot);
blah, blah, blah..., refer to the Developer Guide bah.