Execution against Oracle returns ORA-00922: missing or invalid option
- Dominant language
- C#
- Stars
- 297
- Forks
- 55
- Avg merge
- 18m
- Merged PRs (30d)
- 1
Description
**Describe the bug**
I'm attempting to use grate against an Oracle container (gvenzl/oracle-xe) and am constantly running into ORA-00922: missing or invalid option. The research that I've done on that error indicates that there is something wrong with the syntax of the statement I'm trying to run, however, I've manually executed it using Oracle SQL Developer as well as [DBUp](https://dbup.readthedocs.io/en/latest/) successfully. Here's one of the statements I'm trying to run that fails
CREATE TABLE actor (
actor_id numeric NOT NULL ,
first_name VARCHAR(45) NOT NULL,
last_name VARCHAR(45) NOT NULL,
last_update DATE NOT NULL,
CONSTRAINT pk_actor PRIMARY KEY (actor_id)
);
**To Reproduce**
Add the following to a file called `script0001.tables.sql` in the `up` folder
CREATE TABLE actor (
actor_id numeric NOT NULL ,
first_name VARCHAR(45) NOT NULL,
last_name VARCHAR(45) NOT NULL,
last_update DATE NOT NULL,
CONSTRAINT pk_actor PRIMARY KEY (actor_id)
);
**Expected behavior**
The execution should successfully complete and create a table called `actor`
**Screenshots**
If applicable, add screenshots to help explain your problem.
**Desktop (please complete the following information):**
- OS: Windows Server 2019
- Version 1.4.0
**Additional context**
Add any other context about the problem here.
Contributor guide
Assessment
This issue has not been assessed yet.