CFSTOREDPROC + CFMX 7 + Oracle 10g R2 doesn't work

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default CFSTOREDPROC + CFMX 7 + Oracle 10g R2 doesn't work

    For anyone calling Oracle stored procedures in CFMX 7 using CFSTOREDPROC , I
    thought I would pass on our finding that the JDBC drivers that Macromedia
    posted on 5/13/2005 (version 3.40.50) do not work with Oracle 10g release 2
    (R2, 10.2). You can use CFQUERY with these drivers but CFSTOREDPROC returns a
    Net8 Protocol error when trying to return a resultset. The 5/13/2005 drivers
    WILL work with Oracle 10g release 1. The date of this posting is 8/7/2005.
    Presumably, these drivers will be updated to be compatible with 10g R2.

    Mitch Rubin

    xrubin Guest

  2. Similar Questions and Discussions

    1. CF MX7 <cfstoredproc> with Oracle
      O.k. I am getting the following error using CF MX7 when I create a new record, but update works fine. However, this works fine on CF MX6.1 ERROR:...
    2. CFSTOREDPROC to Oracle on Linux fails - same query onWin2003 works
      Hi folks I hope you can help me. I'm having a terrible time trying to get a query to work. I've got a CF MX6.1 Standard system talking to an...
    3. cfstoredproc oracle error code 6550
      The stored procedue runs in Oracle (SQL Plus). When the stored procedure is run using ColdFusion it throws error: wrong number or types or...
    4. Oracle on CFMX 7
      "Bill_Sahlas" <bsahlas@macromedia.com>, haber iletisinde şunları yazdı:cugmdg$1lt$1@forums.macromedia.com... Is this still true for new JDBC...
    5. cfstoredproc for oracle driver
      I am currently running on CF 5 Standard and an Oracle 9i db. The problem is that we had to use the oracle driver to run stored procs in CF 5. Is...
  3. #2

    Default Re: CFSTOREDPROC + CFMX 7 + Oracle 10g R2 doesn't work

    I just learned this one... the hard way!!

    Trashing R2 and going back to R1.
    PHANYL Guest

  4. #3

    Default Re: CFSTOREDPROC + CFMX 7 + Oracle 10g R2 doesn't work

    The 3.4 drivers only officially support R1.

    The 3.5 drivers support beyond that.

    We've tested 3.5 lightly internally but have not released this build to
    customers yet since they are relatively new.

    Stephen Dupre
    Macromedia QA

    sdupre Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139