view procedures 
Author Message
 view procedures
Hi All:

How do you look at the code that is part of a procedure???? What DBA views
or tables will tell me this information?

Thanks in advance for any help here.
Eddie Lufker



Sun, 23 May 2004 04:08:14 GMT
 view procedures

DBA_SOURCE
USER_SOURCE

Captured from TOAD:
select  TEXT
  from DBA_SOURCE
  where OWNER= :lOWNER
    and NAME=:NAME
    and type = :BTYPE
  order by LINE


Quote:
> Hi All:

> How do you look at the code that is part of a procedure???? What DBA views
> or tables will tell me this information?

> Thanks in advance for any help here.
> Eddie Lufker



Sun, 23 May 2004 05:04:20 GMT
 view procedures
Hi,

USER_SOURCE, ALL_SOURCE, DBA_SOURCE.

Regards,


Quote:

>Hi All:

>How do you look at the code that is part of a procedure???? What DBA views
>or tables will tell me this information?

>Thanks in advance for any help here.
>Eddie Lufker

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com


Sun, 23 May 2004 12:00:30 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. iif functions in views / procedures

2. messages from view/procedure

3. Crosstab View/procedure

4. T.O.A.D. problem (viewing procedures in object browser)

5. Creating views/procedures using ADOX in Access DB

6. Hows to copy data, views, procedures from a tablesapce to another tablespace in ORA 8.0.x

7. Please help to convert view on views to stored procedure

8. Please help to convert view on views to stored procedure

9. stored procedure for viewing views...

10. temporary tables in stored procedures/parameter views vs stored procedures

11. View what stored procedures are currently in the procedure cache

12. Stored procedure dependancy on tables, views and other stored procedures


 
Powered by phpBB® Forum Software