包头:
create or replace package pack_data is
procedure proc_test(recordCount out number);
end pack_data;
编译无误!
包体:
CREATE OR REPLACE PACKAGE BODY pack_data as
procedure proc_test(recordCount out number)
is
begin
select count(*) into recordCount from data;
end;
end;
包体编译出现的错误信息:
PL/SQL: ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-320: 此表达式的类型说明不完整或格式不正确Error: PL/SQL: SQL Statement ignored目标指向的就是那个sql语句啊!~
求大侠指点迷津啊!
求大侠指点迷津啊!
求大侠指点迷津啊!
create or replace package pack_data is
procedure proc_test(recordCount out number);
end pack_data;
编译无误!
包体:
CREATE OR REPLACE PACKAGE BODY pack_data as
procedure proc_test(recordCount out number)
is
begin
select count(*) into recordCount from data;
end;
end;
包体编译出现的错误信息:
PL/SQL: ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-320: 此表达式的类型说明不完整或格式不正确Error: PL/SQL: SQL Statement ignored目标指向的就是那个sql语句啊!~
求大侠指点迷津啊!
求大侠指点迷津啊!
求大侠指点迷津啊!
CREATE TABLE data
(id NUMBER(3));INSERT INTO data
VALUES(1);COMMIT;CREATE OR REPLACE PACKAGE pack_data
IS
PROCEDURE proc_test
(recordCount OUT NUMBER);
END pack_data;
/CREATE OR REPLACE PACKAGE BODY pack_data
AS
PROCEDURE proc_test
(recordCount OUT NUMBER)
IS
BEGIN
SELECT COUNT(*)
INTO recordCount
FROM data;
END;
END;
/你试试?
select into或者是count函数对于表有特殊的要求吗?
是不是NLS_DATE_FORMAT的问题,如果是,try:
alter session set nls_date_format=''yyyy.mm.dd hh24:mi:ss''
多谢大家捧场,谢谢谢谢!