File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

Stored procedure problem

Shashi Iyy

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

Joined: Dec 20, 2006
Posts: 2531

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
Consider Paul's rocket mass heater.
subject: Stored procedure problem