koja
Member³
we use the following valid header for our methods in order to keep readable version and author information even when objects are wrapped.
PL/SQL Developer does have issues with this, when reading methods from the database:
1) the schema_name including the dot appear on the create or replace line and the package_name in its original position including spaces in front of it.
2) the interface notices 2 blocks, but is no longer capable of identifying them as spec and body.
create or replace package
--
-- $Type : PKS $
-- $Name : schema_name.package_name (header) $
-- $Abstract : blabla $
-- $Creator : Creator_name $
--
-- $Revision : 1.0 $
-- $Author : author $
-- $Modtime : 06-12-2019 $
--
schema_name.package_name is
--
--******************************************************************************
When saving the source to file the format remains this way:
create or replace package xxyss_forwarding.
--
-- $Type : PKS $
-- $Name : schema_name.package_name (header) $
-- $Abstract : blabla $
-- $Creator : Creator_name $
--
-- $Revision : 1.0 $
-- $Author : author $
-- $Modtime : 06-12-2019 $
--
pkg_csvutil is
--
--******************************************************************************
PL/SQL Developer does have issues with this, when reading methods from the database:
1) the schema_name including the dot appear on the create or replace line and the package_name in its original position including spaces in front of it.
2) the interface notices 2 blocks, but is no longer capable of identifying them as spec and body.
create or replace package
--
-- $Type : PKS $
-- $Name : schema_name.package_name (header) $
-- $Abstract : blabla $
-- $Creator : Creator_name $
--
-- $Revision : 1.0 $
-- $Author : author $
-- $Modtime : 06-12-2019 $
--
schema_name.package_name is
--
--******************************************************************************
When saving the source to file the format remains this way:
create or replace package xxyss_forwarding.
--
-- $Type : PKS $
-- $Name : schema_name.package_name (header) $
-- $Abstract : blabla $
-- $Creator : Creator_name $
--
-- $Revision : 1.0 $
-- $Author : author $
-- $Modtime : 06-12-2019 $
--
pkg_csvutil is
--
--******************************************************************************