Home » SQL & PL/SQL » SQL & PL/SQL » Edit an Existing Stored Procedure/Trigger in Notepad
icon5.gif  Edit an Existing Stored Procedure/Trigger in Notepad [message #247559] Tue, 26 June 2007 06:48 Go to next message
rajvaida
Messages: 26
Registered: May 2006
Location: India
Junior Member

Hello...

I want to edit an Existing Stored Procedure/Trigger in Notepad. How can i do it. They SQL Developer didn't store some procedures in sql file.

All are working stored procedures, able to access from user_source. But how can i edit directly?

I guess, you guys can understood my question. Pls do reply.

Regards

Raj
Re: Edit an Existing Stored Procedure/Trigger in Notepad [message #247561 is a reply to message #247559] Tue, 26 June 2007 06:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64108
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Directly, you can't.
Spool the source into a file then edit it.

Regards
Michel
Re: Edit an Existing Stored Procedure/Trigger in Notepad [message #247574 is a reply to message #247561] Tue, 26 June 2007 07:30 Go to previous messageGo to next message
rajvaida
Messages: 26
Registered: May 2006
Location: India
Junior Member

oh.. Ok.

i am doing it by accessing the souce from user_soure table.

anyway.. thanks for your support
Re: Edit an Existing Stored Procedure/Trigger in Notepad [message #247620 is a reply to message #247574] Tue, 26 June 2007 10:01 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
I hope you don't think about updating that view directly...
Previous Topic: String parsing
Next Topic: Query not working in 10g.
Goto Forum:
  


Current Time: Mon Dec 05 04:59:56 CST 2016

Total time taken to generate the page: 0.18003 seconds