aspose file tools*
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: 2510
    
  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
youtube channel
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Stored procedure problem