Passing array or object to an ORACLE stored procedure

[NeedAleve]

I normally code in Java and have found myself tasked to correct a few problems in some legacy code that was written in VB6 using ADODB to connect to an ORACLE Database. I need to be able to pass a collection such as an array or a custom defined DB type from the VB code to an ORACLE 9i database. Is this possible in VB6 using ADODB? If so could someone shed some light on how?

Thanks in advance.

[Hack]

Welcome to the forums.

I suspect so.

Can you give me an example of what you need to pass?

[NeedAleve]

Currently we have a stored procedure that takes a comma separated list of values. The values are based on user selection. When the list, which is held in a String, gets up around 254 characters we get an error from the database stating that the input is to long. We are hoping to get by this limitation by passing in an Array from VB to the Oracle stored procedure.

Any help would be appreciated.

[szlamany]

I can't imagine that there is a 255 character max to a parameter - but I could be wrong...

Have you looked at the definition of the SPROC to see what the size of that parameter is set to be??

btw - edit your first post - go advanced - and add to the thread title the word ORACLE - there are ORACLE people on board here...