create or replace package jutiPackage as type centk is ref cursor;function thni (pltr in varchar2) return jutiPackage.centk end jutiPackage; / create or replace function thni (pltr in varchar2) return jutiPackage.centk as begin outrs jutiPackage.centk; open outrs for pltr; return outrs; end thni;/
sorry,后面改为:CREATE OR REPLACE PACKAGE BODY jutiPackage as create or replace function thni (pltr in varchar2) return jutiPackage.centk as begin outrs jutiPackage.centk; open outrs for pltr; return outrs; end thni; end jutiPackage;
错误如下:PLS-00103: Encountered the symbol "JUTIPACKAGE" when expecting one of the following: . @ % ; is authid deterministic parallel_enable as character The symbol "." was substituted for "JUTIPACKAGE" to continue.
返回值只能是类型,不能是某个具体变量要返回某个具体变量请用传出值 CREATE OR REPLACE PACKAGE BODY jutiPackage as create or replace function thni (pltr in varchar2) return number as begin outrs jutiPackage.centk; open outrs for pltr; return outrs; end thni; end jutiPackage;
返回值只能是类型,不能是某个具体变量要返回某个具体变量请用传出值 CREATE OR REPLACE PACKAGE BODY jutiPackage as create or replace function thni (pltr in varchar2) return ref cursor as begin outrs jutiPackage.centk; open outrs for pltr; return outrs; end thni; end jutiPackage;
create or replace function thni (pltr in varchar2)return jutiPackage.centk as outrs jutiPackage.centk; beginopen outrs for pltr;return outrs; end thni;
as
type centk is ref cursor;function thni (pltr in varchar2)
return jutiPackage.centk
end jutiPackage;
/
create or replace function thni (pltr in varchar2)
return jutiPackage.centk
as
begin
outrs jutiPackage.centk;
open outrs for pltr;
return outrs;
end thni;/
create or replace function thni (pltr in varchar2)
return jutiPackage.centk
as
begin
outrs jutiPackage.centk;
open outrs for pltr;
return outrs;
end thni;
end jutiPackage;
one of the following:
. @ % ; is authid deterministic parallel_enable as character
The symbol "." was substituted for "JUTIPACKAGE" to continue.
CREATE OR REPLACE PACKAGE BODY jutiPackage as
create or replace function thni (pltr in varchar2)
return number
as
begin
outrs jutiPackage.centk;
open outrs for pltr;
return outrs;
end thni;
end jutiPackage;
CREATE OR REPLACE PACKAGE BODY jutiPackage as
create or replace function thni (pltr in varchar2)
return ref cursor
as
begin
outrs jutiPackage.centk;
open outrs for pltr;
return outrs;
end thni;
end jutiPackage;
as
outrs jutiPackage.centk;
beginopen outrs for pltr;return outrs;
end thni;