On Mon, Jun 21, 2010 at 3:01 PM, Dunbar, Norman <norman.dunbar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote: > Hi Sven, > You need to look in the USER_SOURCE view: > > Select text > from user_source > where type = 'FUNCTION' > and name = 'WHATEVER' > order by line; [...] Hi folks thanks for all answers. have a nice day cheers Sven -- //www.freelists.org/webpage/oracle-l