Home » SQL & PL/SQL » SQL & PL/SQL » Stored Proceudure (Oracle 9i,HP-Unix Environment)
Stored Proceudure [message #291376] Fri, 04 January 2008 01:01 Go to next message
pushkar.verma
Messages: 1
Registered: January 2008
Junior Member
Hi,

I have just stored a function in my database. How can I view this function and modify it.You could also mail me at pushkar.verma@rediffmail.com

Thanks
Pushkar

[Updated on: Fri, 04 January 2008 01:02]

Report message to a moderator

Re: Stored Proceudure [message #291387 is a reply to message #291376] Fri, 04 January 2008 01:19 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
I don't know why you have posted in this forum.

Anyway you can check the code in user_source table.
Change the code and run the script again.
You may need to add "create or replace" at the beginning.

By
Vamsi
Re: Stored Proceudure [message #291391 is a reply to message #291376] Fri, 04 January 2008 01:23 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can also use dbms_metadata package to get the source.
Or use a tool like SQL Developer.

Regards
Michel
Previous Topic: moving records
Next Topic: Calling member procedure from member function
Goto Forum:
  


Current Time: Fri Dec 09 06:10:03 CST 2016

Total time taken to generate the page: 0.08169 seconds