oracle动态表名问题?
CREATE OR REPLACE PROCEDURE DONGTAITABLENAME(tablename in varchar2, cur out sys_refcursor) AS
v_sql varchar2(200);
BEGIN
v_sql:='select sal from'||tablename;
open cur for v_sql;
END DONGTAITABLENAME;
在JAVA 中调用提示
java.sql.SQLException: Invalid column index
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameterInternal(OracleCallableStatement.java:124)
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java:300)
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java:389)
at oracle.jdbc.driver.OracleCallableStatementWrapper.registerOutParameter(OracleCallableStatementWrapper.java:1568)
at ArrayCopyDemo.main(ArrayCopyDemo.java:26)
这个是怎么回事呢