存储过程内容:
(pdno IN VARCHAR2) is
begin
INSERT INTO 表1(字段1,字段2,......)
SELECT 字段1,字段2,...... FROM 表2 WHERE 字段3 = pdno;
end;错误信息:
ORA-06550: line 1, column 7:
PLS-00201:identifier 'CUS_MFC0012021' must be declared
ORA-06550:line 1,column 7;
PL/SQL:Statement ignored.
(pdno IN VARCHAR2) is
begin
INSERT INTO 表1(字段1,字段2,......)
SELECT 字段1,字段2,...... FROM 表2 WHERE 字段3 = pdno;
end;错误信息:
ORA-06550: line 1, column 7:
PLS-00201:identifier 'CUS_MFC0012021' must be declared
ORA-06550:line 1,column 7;
PL/SQL:Statement ignored.
SELECT 字段1,字段2,...... FROM 表2 WHERE 字段3 = pdno;
create or replace procedure pr_test(pdno varchar2) is
begin
INSERT INTO 表1(字段1,字段2,......)
SELECT 字段1,字段2,...... FROM 表2 WHERE 字段3 = pdno;end pr_test;