Skip to main content
C
codism
Participant
September 9, 2008
Question

Returning Objects From Oracle

  • September 9, 2008
  • 1 reply
  • 321 views
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
This topic has been closed for replies.

1 reply

N
Newsgroup_User
Inspiring
September 9, 2008
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.

C
codismAuthor
Participant
September 10, 2008

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??
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices