Converting CF 5.0 procedure calls to MX

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

  1. #1

    Default Converting CF 5.0 procedure calls to MX

    When I try to call my database procedure from within my source code, I receive
    the follow error:
    [Macromedia][SequeLink JDBC Driver]Output parameters with batch updates are
    not supported.
    I was only able to find one website that gave a little bit of an explanation:
    Cause You cannot use output parameters with batch updates.
    Action Check your JDBC application.

    I'm not doing any batch update or any updates in my procdure. I am passing
    parameters to my procedure and having them return values back to me through my
    <CFPROCPARAM> tag. I am connecting to my ORACLE database through an ODBC
    socket. Any help would be GREATLY appreciated!!!!!!!!!!!!!

    scurlo9ck Guest

  2. Similar Questions and Discussions

    1. Converting cfquery to TSQL stored procedure
      Does anyone know how to convert this cfquery to TSQL code. The goal is to have MS SQL 2000 run this query in a stored procedure for the sake of...
    2. DDL calls from SQL PL
      Hi, When I try to run/compile the following SQL PL, I get errors for the DDL statements used in them. For example, the GRANT and DROP statements...
    3. Help, MVS DB2 Remote Stored Procedure calls
      I'm having trouble executing a remote SP call. I'm running a mainframe system on z/OS using COBOL LE/370 and DB2 V6 My application is running on...
    4. Trapping errors from stored procedure calls
      We often use code in stored procedures for premature exit, such as SET @returnerror = @@ERROR IF ( @returnerror <> 0 ) BEGIN RAISERROR(...
    5. Creating a trigger that calls a stored procedure
      Hi, Using JAVA (JDBC), I'm trying to create a trigger that calls a stored procedure. However there seems to be something wrong with my syntax...
  3. #2

    Default Re: Converting CF 5.0 procedure calls to MX

    What ODBC driver are you using, Microsoft's or Oracle's? I would recommend
    using the one from Oracle that is appropriate for your version of the database.

    [url]http://www.oracle.com/technology/software/tech/windows/odbc/index.html[/url]

    Phil

    paross1 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