Query for specific procedure's source code

From: Adam Cameron <adam_junk_at_hotmail.com>
Date: Sat, 28 Feb 2009 16:39:52 +0000
Message-ID: <ahgrdoujkazu$.zmg3y774z59x.dlg_at_40tude.net>

Hi
Is there any way one can query for a specific procedure's source code, rather than the entire package body that it's within?

I know I can query user_source for the package body, or for stand-alone procs, but I'm struggling to find a nice way of pulling out just the code for a specific proc within the package.

I suppose I can pull out everything between the start of the proc I want through to the start of the next proc, but I'd've thought there'd be a more elegant way of doing it than that?

I'm looking _at_ Oracle 9i at present, but I'd be keen to know about solutions for other releases too. Any thoughts _at_ all, really.

-- 
Adam

Received on Sat Feb 28 2009 - 10:39:52 CST