File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Oracle/OAS and the fly likes Using user_source Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Using user_source" Watch "Using user_source" New topic
Author

Using user_source

Sudarshan Sreenivasan
Ranch Hand

Joined: Jun 28, 2007
Posts: 188

Hi,

I want to user the user_source view to find out all the say 'procs' which have inserted a value in a column named effto in my database




The above query may work but will fail if insert and effto where in different lines in the proc.

Can anyone suggest a query that can help me retrieve the required rows ?
Sudarshan Sreenivasan
Ranch Hand

Joined: Jun 28, 2007
Posts: 188



This is what i was looking for

Thanks
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Using user_source
 
Similar Threads
Meta Data for Oracle Store Procedures?
Viewing Stored Procedure in SQL plus
Database Metadata
Search query is taking too long to search
View Stored Procedure