开发者

querying the RESTRICT_REFERENCES pragma

开发者 https://www.devze.com 2023-01-25 23:14 出处:网络
How can I programmatically find out if a package procedure i开发者_如何学Gos flagged with any of the RESTRICT_REFERENCES pragmas (WNDS, WDPS, RNDS...)?The only way I can tell is to query the package s

How can I programmatically find out if a package procedure i开发者_如何学Gos flagged with any of the RESTRICT_REFERENCES pragmas (WNDS, WDPS, RNDS...)?


The only way I can tell is to query the package source code, e.g.:

select text from all_source
where UPPER(text) like '%PRAGMA RESTRICT_REFERENCES%'
and owner = :owner
and name = :package_name
and type = 'PACKAGE';

Not totally reliable (this won't pick it up if the pragma definition is split across multiple lines or has an extra space or something).

0

精彩评论

暂无评论...
验证码 换一张
取 消