3 Replies Latest reply on Sep 10, 2008 2:52 AM by Newsgroup_User

    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
        • 1. Re: Returning Objects From Oracle
          Level 7
          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.

          • 2. Re: Returning Objects From Oracle
            codism Level 1

            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??
            • 3. Re: Returning Objects From Oracle
              Level 7
              > 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