Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-3071

Oracle spits out "PL/SQL: ORA-01704: string literal too long" when string value is over 4000

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.8.3, 2.0.2
    • Fix Version/s: 2.0.5rc1, 2.1.0
    • Component/s: Server (S)
    • Labels:

      Description

      4312:20100927:101526.603 [Z3005] Query failed: [-1] ORA-06550: line 58, column 83:
      PL/SQL: ORA-01704: string literal too long
      ORA-06550: line 58, column 1:
      PL/SQL: SQL Statement ignored
      [begin
      ...
      ...
      insert into history_text (id,itemid,clock,value) values (3792433,57033,1285607722,'lots of text');
      end;
      ]

      Fix is by setting bind variables or by using dbms_sql

      I found this solution here:
      http://www.experts-exchange.com/Database/Oracle/Q_21706207.html

      Ask Tom has a better explanation if you want to use
      http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:7032414607769

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              sj7trunks Benjamin Coles
            • Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: