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

          Zeplin

            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 Integration