Tuesday, May 26, 2009

body of the store procedure

SQL> desc user_source
Name Null? Type

-------- ----
NAME VARCHAR2(30)
TYPE VARCHAR2(12)
LINE NUMBER
TEXT VARCHAR2(4000)

select text from user_source
where name = 'YOUR_PROCEDURE'
order by line;
Hi all,
I ran the following statement to get the body of the store procedure:
select text from user_source where name =

and the long text(body of store procedure) is returned back. This store procedure is created with the error message return back as "Warning: Procedure created with compilation errors". So I were wondering why the store procdure is in user_source although the creation of this store procedure is returned an error message as mentioned above. Is there anyway that we can find out if the store procedure is created with the compilation errors.

No comments:

Post a Comment