Re: obtaining the PL/SQL code of packages ??

Bagieta wrote:

> select text from user_source where name='YOUR_PACKAGE_NAME'
> and type = 'PACKAGE BODY' order by line

Or use the DBMS_METADATA built-in package: http://www.psoug.org/reference/dbms_metadata.html

PS: Bagieta ... I've noted that you have tried to help an OP. Now you'll get more respect when talking about spamming. I still won't agree with you but you'll get more respect. ;-)

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)