OraFAQ Forum: SQL & PL/SQL » all

Home » SQL & PL/SQL » SQL & PL/SQL » all_source

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

all_source [message #39446]

Wed, 17 July 2002 12:07

annie
Messages: 30
Registered: March 2000

Member

I can execute a procedure, but can not find it in all_source/user_source table. Is there another way to find the source code of the procedure?

Thanks

Report message to a moderator

Re: all_source [message #39451 is a reply to message #39446]

Wed, 17 July 2002 14:10

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

is it a packaged procedure?

Report message to a moderator

Re: all_source [message #39455 is a reply to message #39451]

Wed, 17 July 2002 16:51

Pankaj Mandalia
Messages: 1
Registered: July 2002

Junior Member

Give yourself or this user 'grant select on dba_source to <username>;' after logging in as system.

Then login as this user and do a

set long 20000

select text from dba_source where name = ''Your_procedure_name';

This should give you the source of your procedure

HOpe it helps

Pankaj,

Report message to a moderator

Previous Topic:	'######' in number field.
Next Topic:	ORA Error -1841

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 10 20:29:28 CDT 2024