Re: Procedure Help

set heading off
set feedback off
set pagesize 0
spool objs.txt
select text from user_source order by name,line spool off;
This will create a file which has got all the functions , procedures etc owned by the user how has loged in to the system. in order to modify that copy a funtion in to a file add create or replace function (if procedure then create or replace procedure etc) modify the function, save the file, from sqlplus @path to the file.

OR
GET Toad or SQLNavigator to modify objects. Tom

Enchanted <no_at_spam.com> wrote in message news:39737a0c.1059904281_at_news.attcanada.net...
>
> I'm new to Oracle but can usually get my way around SQL when
> necessary. My terminology might not be completely correct, but
> perhaps someone can understand me enough to help me out.
>
> I have to modify some procedures but I'm not sure how to access them.
> I found I can list them by using:
>
> select * from user_objects
> where object_type = 'PROCEDURE'
>
> But I can't seem to find out how to edit procedure X or Y even if
> they're listed there.
>
> I've tried searching through documentation but couldn't find what I
> wanted. If someone could provide some help or direct me to any
> relevant URLs, it would be much appreiciated.
>
> enchanted
>
Received on Tue Jul 18 2000 - 00:00:00 CDT