|
|
| Database: |
Oracle
|
| URL: |
/mod/wiki/view.php...
|
| Participants: |
D P and Eloy Lafuente (stronk7)
|
| Security Level: |
None
|
| Resolved date: |
06/Aug/07
|
| Affected Branches: |
MOODLE_17_STABLE, MOODLE_18_STABLE
|
| Fixed Branches: |
MOODLE_17_STABLE, MOODLE_18_STABLE, MOODLE_19_STABLE
|
|
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?!
|
|
Description
|
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?! |
Show » |
|
www.oracle.com/technology/pub/articles/oracle_php_cookbook/fuecks_lobs.html