viewing procedures

[Jalr2003]

Hi,

Is there a way to retreive the source code of a procedure using sqlplus? I use describe, but I does not show the code.

If not, what is the best way?

Thanks,

Jalr2003

 

[carp]

SELECT text
FROM dba/all/user_source
WHERE name = 'MY_PROCEDURE'
ORDER BY line;

Elbert, CO
0835 MST

 

[sem]

I'l also suggest to specify TYPE (as both package spec and body share the same name), and probably OWNER for DBA_|ALL_ views.

Regards, Dima

http://seminihin.narod.ru

 

[Jalr2003]

Thanks for your help.

 

[sbix]

to see the full text remember to execute a "set long 20000" before to execute the select command.

 

[sem]

Sbix, contrary to USER|ALL|DBA_VIEWS, USER|ALL|DBA_TABLES doesn't contain LONG fields: sources are stored line-by-line in VARCHAR2s. So your advise passes ahead of Jalr2003's coming question: how to get view creation statement

Regards, Dima

http://seminihin.narod.ru

 

[sbix]

Aaaaargh!!!! You're correct ... as usual ... SHAME ON ME!!!