Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-9751

ORA-01704: content of a wiki page is too long, when trying to save

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Critical Critical
    • 1.7.3, 1.8.3, 1.9
    • 1.7, 1.7.1, 1.7.2, 1.8
    • Database SQL/XMLDB
    • None
    • Solaris 10,
      Oracle 10g
    • Oracle
    • MOODLE_17_STABLE, MOODLE_18_STABLE
    • MOODLE_17_STABLE, MOODLE_18_STABLE, MOODLE_19_STABLE
    • /mod/wiki/view.php...

      Someone wanted to save a really long wiki page and got only [[errorsaving]] as error-message (its from within ewiki.php)
      The following ORA error message is thrown, when developer messages are on:

      ORA-04098: trigger 'ORA_MONITOR.ALERT_TR_ERRORS' is invalid and failed re-validation ORA-01704: string literal too long

      INSERT INTO m_wiki_pages ( PAGENAME, VERSION, FLAGS, CONTENT, AUTHOR, USERID, CREATED, LASTMODIFIED, REFS, META, HITS, WIKI ) VALUES ( 'Übungsaufgabe 2.1 - Antwort', 4, 1, '
      .......
      here comes the really huge content text of the wiki page...approximately 3900 characters
      .......
      ', 'dednis drotger (123.134.62.153:2362)', 3, 1177657076, 1178630599, ' Sozialversicherungsbeiträge Sozialbeiträge Prioritäten Einschränkung Ausbildungsplätzen Universität Tertiärbereich ', '', 106, 312 );

      Do you have to use a special variable for this INSERT
      or is the (clob,4000) column for "content" too short?!

            stronk7 Eloy Lafuente (stronk7)
            protzek D P
            Nobody Nobody
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.