Reading from columns of 'NCLOB' data type not possible

XMLWordPrintable

    • Type: Incident report
    • Resolution: Cannot Reproduce
    • Priority: Critical
    • None
    • Affects Version/s: 1.8.4
    • Component/s: Frontend (F)
    • Environment:
      Server: ZABBIX 1.8.4 (Oracle Call Interface)
      Server Database: Oracle RDBMS 11.2.0.1
      OS: CentOS release 5.5
      PHP: 5.1.6-27.el5_5.3
      PHP OCI8-Module: 5.1.6-27.el5_5.3 with oracle-instantclient11.2-basic-11.2.0.2.0-1

      Every attempt by the GUI(PHP) to fetch data from 'NCLOB' columns fails with the following error message:

      OCI-Lob::load() [<a href='function.OCI-Lob-load'>function.OCI-Lob-load</a>]: ORA-24806: LOB form mismatch[/usr/share/zabbix/include/db.inc.php:626]

        1. 3693.patch
          0.6 kB
        2. 3693.patch.png
          3693.patch.png
          33 kB
        3. history_log-gui.png
          history_log-gui.png
          23 kB
        4. history_log-sqlplus.png
          history_log-sqlplus.png
          15 kB
        5. nls_database_parameters_2.txt
          1 kB
        6. nls_database_parameters.txt
          1 kB

            Assignee:
            Alexander Vladishev
            Reporter:
            Marc
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: