Stored Procedure Help!!!

From: Vivek Dabholkar <vivek_dabholkar_at_my-deja.com>
Date: Tue, 26 Sep 2000 17:25:46 GMT
Message-ID: <8qqm6i$4qk$1@nnrp1.deja.com>

I am writing an Oracle stored procedure. Procedure is accepting a string as a parameter. The string is in the following format.

'1111,1111,1111;2222,2222,2222;'.

I need to parse this string inside the procedure and manipulate the data.

I wanted to parse the string in such a way that I can define a cursor and which will return me the result in the form of recordset.

For Example: SELECT somefunc
('1111,1111,1111;2222,2222,2222;', ';') 'Records' FROM DUAL; Result of the query:
Records

---

1111,1111,1111;
2222,2222,2222;

If I get this working I can easily manipulate the result set.

Can anyone help me to find "somefunc" from above query, please.

Thanks a lot in advance.

-Vivek.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 26 2000 - 12:25:46 CDT