执行存储过程,报错PLS-0021 EXecute 不是过程或尚未定义
CREATE OR REPLACE procedure proInsertCustInfo(
v_Names in VARCHAR2,
v_param1 in VARCHAR2,
v_param2 in VARCHAR2
) AS
v_Cursor NUMBER;
v_CreateString VARCHAR2(500);
begin
v_Cursor := DBMS_SQL.OPEN_CURSOR;
v_CreateString := 'INSERT INTO A( ColumnA, ColumnB,' || v_Names || ')' || ' VALUES ('||v_param1||','||v_param2||',SYSDATE)';
DBMS_SQL.PARSE(v_Cursor, v_CreateString, DBMS_SQL.NATIVE);
DBMS_SQL.EXECUTE(v_Cursor);
DBMS_SQL.CLOSE_CURSOR(v_Cursor);
commit work;
end proInsertCustInfo;
执行如下图:
在语句中添加v_num即可
参考文章