Monday, January 05, 2009

Oracle - How To: Get the source for your package

Here are a couple of scripts that will let you get your hands on the source for your package as stored by the database.

Select  TEXT 
from SYS.USER_SOURCE 
where NAME='Package Name' 
and TYPE='PACKAGE' 
order by LINE;

Select  TEXT 
from SYS.USER_SOURCE 
where NAME='Package Name'
and TYPE='PACKAGE BODY'
order by LINE;

What was surprising to me, was that the code is stored as a separate record for each line in the package.

No comments:

Post a Comment

Remember, if you want me to respond to your comment, then you need to use a Google/OpenID account to leave the comment.