How to view content of packages procedures

[EdilsonAndrade]

Dear,

I started playing these days with Oracle, and I have a doubt for how much.

I know that this command

Select all

select * 
 from all_procedures 
 where owner = 'OWNER' AND 
  object_name = 'packagename' 
  AND PROCEDURE_NAME= 'procedure'

Monstrates the procedure of this package

But how do I see the code, body, her content?

Thanks.

[spernega]

Good morning,

Use the ALL_SOURCE.

Select all

select text 
from all_source 
where owner = 'OWNER' 
AND name = 'PACKAGENAME';

[EdilsonAndrade]

Show, thank you very much, they showed only the header or the name and parameters of entry and exit, but it is already good

[spernega]

Show all structure, specification and body.
or two blocks.

ex.

Select all

package pck_gera_xlsx

and

Select all

package body pck_gera_xlsx

[EdilsonAndrade]

beleza, so I can connect again that now I'm having another mistake I see calmly if I lost something, thank you

[EdilsonAndrade]

Hi,

Then I made another here

Select all

   select text 
from all_source 
where name = 'OTN_REF_CURSOR';

He returns:

Select all

"package otn_ref_cursor as 
" 
"  -- used to illustrate passing a ref cursor 
" 
"  -- as a return value from a function 
" 
"  -- or as an output parameter from a procedure 
" 
" 
" 
"  function get_emp_info return sys_refcursor; 
" 
"  procedure get_emp_info(p_rc out sys_refcursor); 
" 
" 
" 
"  procedure get_multiple_cursors(p_rc1 out sys_refcursor, p_rc2 out sys_refcursor, p_rc3 out sys_refcursor); 
" 
end;

realize that it does not show the contents of the procedure get_multiple_cursors, which is the one that has the code that makes the select at the base, I know why I saw the structure I'm using it as an example for this post,

How do I show the tb content of this Package within this package?

Thanks

[EdilsonAndrade]

Hello friend,


Thank you very much, it really shows all the content of PROC, is that I had to descend more pages from the result to see.

Thanks,