Dear all,
I would like to find out if there is a way to retrieve source code of stored procedures/functions from the database. I used to use TOAD to retrieve the source code; however, my TOAD is no longer able to connect to remote database any more. I tried v$sqltext, dba_sql but didn't see what I am looking for.
Thanks,
Unna