PL/SQL (MOSC)

MOSC Banner

Wrapping EDITIONABLE pl/sql packages in 12c

edited Oct 31, 2017 2:26PM in PL/SQL (MOSC) 5 commentsAnswered

Has anybody had success wrapping (wrap.exe) EDITIONABLE packages in 12c?  I get no error but pkg is not wrapped.  If I remove the EDITIONABLE keyword, wrapping works as it should.

Example package that won't get wrapped with command wrap iname=myPkg_E.sql until you remove the keyword EDITIONABLE:

CREATE OR REPLACE EDITIONABLE PACKAGE myPkg_E

AS

   PROCEDURE count_jobs;

END myPkg_E;

/

CREATE OR REPLACE EDITIONABLE PACKAGE BODY myPkg_E

as

   procedure count_jobs

   as

     l_cnt number;

   begin

      select count(*) into l_cnt from sys.dba_scheduler_jobs;

   end count_jobs;

end myPkg_E;

/

Message was edited by: user7910219 I have created an Oracle SR about this, the have created

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center