--创建包cv_types 源代码,成功
create or replace package cv_types is
TYPE EmpCurTyp IS REF CURSOR RETURN SCOTT.emp%ROWTYPE;
end cv_types;--创建过程open_emp_cv源代码,成功
CREATE OR REPLACE PROCEDURE open_emp_cv (emp_cv IN OUT cv_types.EmpCurTyp) AS
BEGIN
OPEN emp_cv FOR SELECT * FROM SCOTT.emp;
END open_emp_cv;--调用过程源代码
declare
emp_cv cv_types.EmpCurTyp;
begin
-- Call the procedure
open_emp_cv(emp_cv);
end;
在执行此源代码时,出现ora-01036:非法的变量名/编号
create or replace package cv_types is
TYPE EmpCurTyp IS REF CURSOR RETURN SCOTT.emp%ROWTYPE;
end cv_types;--创建过程open_emp_cv源代码,成功
CREATE OR REPLACE PROCEDURE open_emp_cv (emp_cv IN OUT cv_types.EmpCurTyp) AS
BEGIN
OPEN emp_cv FOR SELECT * FROM SCOTT.emp;
END open_emp_cv;--调用过程源代码
declare
emp_cv cv_types.EmpCurTyp;
begin
-- Call the procedure
open_emp_cv(emp_cv);
end;
在执行此源代码时,出现ora-01036:非法的变量名/编号
PL/SQL 的TEST WINDOW
转到 SQL WINDOW