Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-41038

Bullhorn table creation fails on Oracle

    XMLWordPrintable

    Details

    • 19 status:
      Verified
    • Test Plan:
      Hide

      Please add a Test Plan here.

      Show
      Please add a Test Plan here.

      Description

      The following is invalid syntax on Oracle:

      create table BULLHORN_ALERTS (ID number(19,0) not null, ALERT_TYPE varchar2(8 char) not null, DEFERRED number(1,0) not null, EVENT varchar2(32 char) not null, EVENT_DATE DATETIME not null, FROM_USER varchar2(99 char) not null, REF varchar2(255 char) not null, SITE_ID varchar2(99 char), TITLE varchar2(255 char), TO_USER varchar2(99 char) not null, URL varchar2(2048 char) not null, primary key (ID))
      

      DATETIME is not a valid datatype. Use DATE instead.

      For testing on Oracle, use this: https://github.com/steveswinsburg/oracle12c-docker

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  a.fish@lancaster.ac.uk Adrian Fish
                  Reporter:
                  steve.swinsburg Steve Swinsburg
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code