Finding and edit stored procedure

[h3nd]

Hi guys,

My DBA is on holiday, so I need to do simple edit for my store procedure in oracle.

So how do I search the "particular store proc" in oracle and open to edit it.

Much appreciated guys...

 

[taupirho]

You can't directly. Unless you can find the original source file you'll need to query the user_source object and get the source out into a file (via spool perhaps), then edit that source file and re-apply to the database

 

[Dagon]

It depends whether you've got tools like TOAD or PL/SQL Developer. With those, you can edit the package and compile it in a window. However, it would be a good idea to make a backup of the procedure first.

 

[h3nd]

what about only to view it ?

 

[KenCunningham]

Query (select from) user_source

I don't mind people who aren't what they seem. I just wish they'd make their mind up.