troubleshooting Question

How can I find/list all the stored procedures and functions in my Oracle DB?

Avatar of afytech1
afytech1 asked on
Oracle Database
17 Comments3 Solutions6304 ViewsLast Modified:
Hi,

I'm running Oracle 7.3.4.  I have a user getting an error when trying to perform an "order entry" type function.  The error text indicates the error is on line 65 in script "fu_allocate_inventory".  How do I locate the script?  How can I view the script?  I'm using sqlplus.

Thanks in advance
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 17 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 17 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros