SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Parse a string

499195Jun 6 2007 — edited Jun 6 2007

Hi All,

I have a procedure which has the following parameters
PROCEDURE order_service (p_organization_in IN VARCHAR2,
p_account_reference_in IN VARCHAR2)

first parameter is sent as a string separated by | delimited which can have from one to many values. I need to be able to parse the string down in my IF condition check for this variable below where i am building a WHERE clause to be passed to a dynamic SELECT statement. My requirement is i should separate the values which are delimited in this string and add quotes and put it in a IN clause along with the WHERE.

How do i acheive this. Can this be done by using SUBSTR or INSTR or combination of both. If so can you share it.
Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 4 2007

Added on Jun 6 2007

2 comments

242 views