Oracle 怎么指定我创建的存储过程创建在我定义的包下?

2025-03-25 10:33:35
推荐回答(1个)
回答1:

如下例子,你在定义包体的时候,同时定义存储过程:

CREATE OR REPLACE PACKAGE BODY PACKXINEM8GL IS

PROCEDURE GL_CREATE_COMPANY_PARAMETER(UQCOMPANYID IN VARCHAR2,

STRDATE IN VARCHAR2,

UQACCOUNTSETID IN VARCHAR2,

STRISGMROLE IN VARCHAR2,

STRISFORCE IN VARCHAR2) IS

STRSQL VARCHAR2(5000);

COMPID VARCHAR2(50);

STRGPDATE VARCHAR2(50);

STRYEARMONTH VARCHAR2(50); --启用年月