Chapter 3 DBMS Reference Guide

Common entries for DB Package

You can define values for the following common entries for the DB Package object in the DBMS definition.

Entry Example (Oracle 9i)
Enable 
Enable = Yes
Maxlen MaxLen = 30
Create Statement for creating the specification of the database package 

create [or replace ]package %DBPACKAGE% [authid %DBPACKAGEPRIV% ][%R%?[is][as]:as]
   %DBPACKAGESPEC%
end [%DBPACKAGE%]
Drop 
drop package %DBPACKAGE%
SqlListQuery 
{{OWNER, DBPACKAGE}

[%ISODBCUSER% ?
select distinct
   %.q:SCHEMA%,
   decode (type, 'PACKAGE', name, '')
from
   sys.user_source
where
   type in ('PACKAGE')
order by
   2
:
select distinct
   owner,
   decode (type, 'PACKAGE', name, '')
from
   sys.all_source
where
   type in ('PACKAGE')
[  and owner = %.q:SCHEMA%]
order by
   1, 2
]
SqlAttrQuery 
{OWNER ID, DBPACKAGE ID, TYPE ID, DBPACKAGESPEC ..., DBPACKAGEBODY ...}

[%ISODBCUSER% ? 
SELECT %.q:SCHEMA%, NAME, TYPE, TEXT, NULL, LINE
FROM SYS.USER_SOURCE S
WHERE TYPE = 'PACKAGE' AND LINE > 1 AND LINE <> (SELECT MAX(S2.LINE) FROM SYS.USER_SOURCE S2  WHERE S2.TYPE = S.TYPE AND S2.NAME = S.NAME) 
UNION
SELECT %.q:SCHEMA%, NAME, TYPE, NULL, TEXT, LINE
FROM SYS.USER_SOURCE S
WHERE TYPE = 'PACKAGE BODY' AND LINE > 1 AND LINE <> (SELECT MAX(S2.LINE) FROM SYS.USER_SOURCE S2  WHERE S2.TYPE = S.TYPE AND S2.NAME = S.NAME) 
ORDER BY NAME, TYPE, LINE
: 
SELECT OWNER, NAME, TYPE, TEXT, NULL, LINE
FROM SYS.ALL_SOURCE S
WHERE TYPE = 'PACKAGE' AND LINE > 1 AND LINE <> (SELECT MAX(S2.LINE) FROM SYS.USER_SOURCE S2  WHERE S2.TYPE = S.TYPE AND S2.NAME = S.NAME) 
UNION
SELECT OWNER, NAME, TYPE, NULL, TEXT, LINE
FROM SYS.ALL_SOURCE S
WHERE TYPE = 'PACKAGE BODY' AND LINE > 1 AND LINE <> (SELECT MAX(S2.LINE) FROM SYS.ALL_SOURCE S2  WHERE S2.TYPE = S.TYPE AND S2.NAME = S.NAME) 
ORDER BY OWNER, NAME, TYPE, LINE
]
ModifiableAttributes List of extended attributes that will be taken into account in the merge dialog box during database synchronization
ReversedStatements List of statements that will be reverse engineered

For a description of each of the common object entries, see section "Common object entries".

 

Copyright (C) 2005. Sybase Inc. All rights reserved.