Where is procedure text??? 
Author Message
 Where is procedure text???



Quote:
>Can someone tell me if there is a table in the data dictionary that holds the
>syntax for procedures / packages that have been created by a user (like the
>text field in DBA_VIEWS) ?

Look at the USER_SOURCE view (or DBA_SOURCE if you prefer).
To see the source for a function named MY_FUNC, issue a
select like this:

        select text
        from user_source
        where name=MY_FUNC
        and type='FUNCTION'
        order by line;

regards,

Jonathan



Wed, 06 Jun 2001 03:00:00 GMT
 
 [ 8 post ] 

 Relevant Pages 

1. Query Analyzer text save - am I missing something?

2. Writing Large Text field to a text File in Stored Procedure

3. stored procedure text no longer appearing in text display window

4. what am I doing wrong in this procedure?

5. Stored Procedure - am I missing something

6. I am attempting to execute a stored procedure as the sql query for a data

7. I am getting this message when i am tring to export or import anything using

8. Where am I wandering in that procedure?

9. Simple question..I am running a stored procedure from SQL PLUS

10. Simple question..I am running a stored procedure from SQL PLUS

11. error ORA-01855: AM/A.M. or PM/P.M. required

12. Busy Day = Slowdown from 12 AM - 5 AM


 
Powered by phpBB® Forum Software