How to iterate trough list in string
Hi,
I tried to find a solution but I found none yet ...
Since MySQL Connector can not pass array as a parameter, I would like to pass in the stored procedure list of ID's in comma-delimited string (parameter type varchar) and then using that list to make multiple inserts or updates.
My question is how to iterate trough string list? If this is impossible then how to do it in a stored procedure?
I was looking for a solution on the forum but have not succeeded to find it. At least not some that works in stored procedure.
I'd also be very grateful if someone publish some example or refer me to some because I have not succeeded to found none of written in the MySQL procedure, only
PHP etc.
I need a solution that works in a stored procedure because it is part of a sequence of transactions.
Thanks in advance!
Edited 1 time(s). Last edit at 12/26/2010 01:57PM by Boris Masnec.
Subject
Views
Written By
Posted
How to iterate trough list in string
4329
December 23, 2010 04:16AM
1436
December 24, 2010 10:59AM
1233
December 26, 2010 01:51PM
1931
December 27, 2010 09:27AM
1387
December 28, 2010 03:48AM
1321
December 28, 2010 03:35PM
1429
December 29, 2010 06:21AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.