Passing arrays between CF and Oracle

[rtefft]

Can anyone show me how to use CFSTOREDPROC where one of the parameters of the procedure is a simple string array? We call procedures all the time, but cannot figure out how to return a simple 1-dimensional string array.



____________________________
Rich Tefft
PL/SQL Programmer

 

[TruthInSatire]

a string array? C++ considers a string an array of chars...

do you mean an array of strings, or a list

We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.

 

[rtefft]

Truth,

I mean an array of multi-byte character strings. For example, an array of 12 elements, each containing a month ('JAN','FEB', 'MAR'...).

Thanks,
Rich

____________________________
Rich Tefft
PL/SQL Programmer

 

[TruthInSatire]

I'd probably send it as a string (list) "jan,feb,mar,..." and use PL/SQL to split it back into an array.

http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-b16.htm#wp1102102

We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.

 

[rtefft]

We were using that, but the various JDBC, ODBC, and thin drivers used between CF and Oracle have limits on string and LOB length (4k on average). I need to send more data than that without using Oracle tables (to keep overhead to a minimum). I was hoping an array datatype might do the trick.

____________________________
Rich Tefft
PL/SQL Programmer