This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes Stored procedure problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Stored procedure problem" Watch "Stored procedure problem" New topic
Author

Stored procedure problem

Shashi Iyy
Greenhorn

Joined: Jun 12, 2008
Posts: 18
Hi All,

I need to write a Oracle stored procedure which takes a String as its input.The string will contain characters separated by a character such as tilde(~),for example,String s = shashi~raju.Inside the procedure,the string should be split into several strings without the separator character.These strings should be set as input in the where clause of a SQL select statement in the procedure.The output of the procedure should be a table containing the resultant rows.How to go about this using Oracle PL/SQL?A example would be very useful for me.Thanks in advance.
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2543
    
  10

Hi Shashi,

Can you show us where you are stuck. If you post your code, we can help you.

Regards, Jan


OCUP UML fundamental and ITIL foundation
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: Stored procedure problem
 
jQuery in Action, 3rd edition