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
Messages: 1
Registered: January 2008
Junior Member

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


[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: 2108
Registered: October 2003
Location: Hyderabad, India
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.

Re: Stored Proceudure [message #291391 is a reply to message #291376] Fri, 04 January 2008 01:23 Go to previous message
Michel Cadot
Messages: 65090
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.

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

Current Time: Fri Jul 28 14:45:14 CDT 2017

Total time taken to generate the page: 0.11205 seconds