更新时间:2022-05-29 22:03:07
如果是一个包,那么你可以通过以下方式获取源代码:
If is a package then you can get the source for that with:
select text from all_source where name = 'PADCAMPAIGN'
and type = 'PACKAGE BODY'
order by line;
Oracle 不会单独存储子程序的源代码,因此您需要查看它的包源.
Oracle doesn't store the source for a sub-program separately, so you need to look through the package source for it.
注意:我假设您在创建该包时没有使用双引号,但如果您使用了,请使用
Note: I've assumed you didn't use double-quotes when creating that package, but if you did , then use
select text from all_source where name = 'pAdCampaign'
and type = 'PACKAGE BODY'
order by line;