Oracle ODBC Socket MX7 Standard Issues ORA-06502

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

  1. #1

    Default Oracle ODBC Socket MX7 Standard Issues ORA-06502

    We have an issue where a stored procedure works fine in MX 6.1 standard but
    does nto work in MX 7 Updater 2 standard. Everything is set up the same. We are
    using ODBC Socket to make the connection to an Oracle 9 database. The
    connection verifies in ColdFusion datasources, and I can return data that is
    not coming back from a reference cursor. Whenever I try and retrieve data from
    a reference cursor, I receive ORA-06502: PL/SQL: numeric or value error:
    character string buffer too small ORA-06512...PL/SQL: numeric or value error:
    character string buffer too small ORA-06512: at line 1.This is not an issue
    with the stored procedure. It works fine in MX 6.1 and CF 5. It also works fine
    if I call it from an ASP application and returns the data. I have updated the
    drivers from 3.3 to 3.5 as well as the sequelLink. Appearently, the updater 2
    didn't update these so I did it manually and verified the versions.

    Does anyone have any recommendations aside from buying the Enterprise version?
    I have tested the native drivers in the Enterprise version and they work
    without any problems. I want to be able to get the socket connection working.

    Thanks!

    jsantelli Guest

  2. Similar Questions and Discussions

    1. Socket ODBC error
      After I submit the ODBC socket, then I got error message saying "Unable to update the ColdFusion MX 7 ODBC Server. Timeout period expired without...
    2. ODBC Socket
      Our system is on Sun Solaris and we need away to read in excel spreadsheet and parse its data into Oracle database. I saw one support article...
    3. ODBC Socket ERROR
      I have a a sql 6.5 that i connect to using odbc sockets on CF 7. It worked fine on my dev machine, but when i installed cf 7 on my production box...
    4. ODBC Socket doesn't show my list of ODBC DSN's!?!
      In the ColdFusion MX 7 Administrator, when I try to create a new datasource of type ?ODBC Socket?, the drop down labled ?ODBC DSN? that is supposed...
    5. 2003 Server - load balancing ODBC and Oracle client issues
      Hi all, I have 4 servers running Windows 2003 Server Standard and IIS 6. We are using them as web servers. They are all load balanced together....
  3. #2

    Default Re: Oracle ODBC Socket MX7 Standard Issues ORA-06502

    Anyone?
    jsantelli 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