Returning Objects From Oracle

[codism]

hi all,

i am trying to find out whether complex datatypes such as arrays and structures be returned to coldfusion from oracle stored procedures?
i know that other languages such as java support this feature.

thanks,
ss

[Newsgroup_User]

codism wrote:
> hi all,
>
> i am trying to find out whether complex datatypes such as arrays and
> structures be returned to coldfusion from oracle stored procedures?
> i know that other languages such as java support this feature.
>
> thanks,
> ss
>

I don't think so. I know I have never done this myself. AFAIK
ColdFusion <cfquery...> or <cfstoredProcedures...> can only return one
or more record sets.

But, it is very easy to extend ColdFusion by diving into the Java
underpinnings, if this is a necessary requirement. So if you can do
this in Java, do it. Then call that with a Java custom tag or
createObject(...) function.

[codism]

I tried using the java db connection functions to run the stored procedure. The problem is that the jdbc driver does not support the array or struct sqltypes.
Is there any workaround to this? I am sure there are jdbc drivers which support the array or struct sqltype. I wonder why coldfusion is not providing the right JDBC drivers??

[Newsgroup_User]

> I wonder why coldfusion is not providing
> the right JDBC drivers??

There's nothing stopping you from using any JDBC drivers you like.

The Data Direct drivers CF ships with are pretty solid in my experience,
but... yeah, seems they don't cover *all* bases.

I'd be keen to hear back on your experiences with other drivers, and
whether they can indeed enable CF to pass more complex data types to/from
Oracle.

--
Adam