Passing a list to an Oracle stored procedure
Anyone know how to process the list?
<cfstoredproc procedure="test" datasource="#application.Datasource#">
<cfprocparam type="in" cfsqltype="cf_sql_varchar" value="#Names#">
</cfstoredproc>
procedure test (Names in varchar2) is
The Names variable from the Cold Fusion page would have values like Joe1,Joe2,Joe3,Joe4.
I need to loop through the Names variable (Joe1 then Joe2 then Joe3 and so on) and insert each one into a table. Any idea on how to do that within the procedure?