-
Improvement
-
Resolution: Won't Do
-
Minor
-
None
-
4.3
-
None
-
MOODLE_403_STABLE
This is a follow up to MDL-78787 where we implemented the same for SQL Server - see points #2 & #3 in this comment in discussion with stronk7. Fixing this would achieve parity with the MySQL, Postgres & SQL Server
Copying the error here (when/if this is issue is resolved, we should increase the character size used in the test from 1300):
1) core\dml_test::test_sql_concat
|
dml_read_exception: Error reading from database (ORA-06502: PL/SQL: numeric or value error: character string buffer too small
|
ORA-06512: at "MOODLE.MOODLELIB", line 86
|
SELECT MOODLELIB.UNDO_MEGA_HACK(MOODLELIB.TRICONCAT(description, 'harcoded', MOODLELIB.TRICONCAT(:o_param1, :o_param2, ' '))) FROM t_test_table
|
[array (
|
'o_param1' => 123.45,
|
'o_param2' => 'test',
|
)])
|
|
/var/www/html/lib/dml/moodle_database.php:494
|
/var/www/html/lib/dml/oci_native_moodle_database.php:277
|
/var/www/html/lib/dml/oci_native_moodle_database.php:1182
|
/var/www/html/lib/dml/moodle_database.php:1774
|
/var/www/html/lib/dml/tests/dml_test.php:4414
|
/var/www/html/lib/phpunit/classes/database_driver_testcase.php:143
|
It looks like a previous attempt was made at achieving the same some time ago in MDL-43816, but that never arrived, and was eventually closed as inactive
- duplicates
-
MDL-43816 Glossary Full Text Search throws ORA-06502: PL/SQL: numeric or value error: character string buffer too small
-
- Closed
-
- has a non-specific relationship to
-
MDL-80166 Plan for cessation of support for Oracle
-
- Closed
-
- has been marked as being related by
-
-
- Closed
-