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

Error wrintg database. ORA-01722: invalid number

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Minor Minor
    • None
    • 3.1.2
    • None
    • MOODLE_31_STABLE

      I have installed Moodle 3.1.2. With Oracle 12C.

      A) The message that appears in Moodle in the administrator when doing a search in the Glossary is:
      Error reading from database
      More information about this error
      B) The message that appears in Moodle in the administrator when trying to create a question (matching or multiple choice) is:
      Failed to write to the database
      More information about this error

      3) The message that appears in Moodle in the administrator when trying to import questions in xml format:
      Failed to write to the database
      More information about this error

      Once checked this message from DBA Oracle, send us the next explanation, from Database:

      Goal Applying to_number to a field containing numbers stored as characters, it returns ora-01722 Example: select to_number('70,59') from dual;

      • * ERROR at line 1: ORA-01722: invalid number Solution:
      • You need to use format string to indicate the format As follows select to_number('70.59','99.99') from dual;

      How can i do resolve this?

            timhunt Tim Hunt
            jpcolombia2015 JUAN ALBERTO
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved:

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