Uploaded image for project: 'Contrib: SCORM Player'
  1. Contrib: SCORM Player
  2. SCO-84

When auto-generating DDL for Oracle, script includes LONG and LONG RAW datatypes

    Details

    • Type: Bug
    • Status: OPEN
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 3.0.0, 11.x, 12.x, 19.x, 20.x
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Oracle

      Description

      Since there was no DDL available (and we do not use auto.ddl on our instances), I added a hibernate DDL generator to the scorm tool. However, the auto-generated Oracle script includes the LONG and LONG RAW datatypes which Oracle advises against using. In addition, the tool blows up if these datatypes are used. Replacing the LONG and LONG RAW with CLOB and BLOB fixed the issues for us. I have attached the auto-generated ddl with the datatype replacement for Oracle.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  wagnermr Michelle Wagner
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:

                    Git Source Code