jakartaee / jakartaee/batch-tck
Oracle DDL script hangs due to missing / after create or replace trigger statement.
Open
Nobody has claimed this yet.
- Dominant language
- Java
- Stars
- 2
- Forks
- 12
- PR merge metrics
- No merged PRs in 30d
Description
In modern Oracle databases, sqlplus hangs on the following statement:
CREATE or
REPLACE trigger order_trigger
BEFORE
INSERT ON Orders
FOR EACH ROW
BEGIN
IF
(:new.orderID IS NULL)
THEN
SELECT order_seq.nextval
INTO :new.orderID
FROM DUAL;
END IF;
END;
To make it work properly, there needs to be a / added after the END; statement.
You really should drop the sequence when dropping the tables at the top of the script too.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No file or test is named; locate the Batch TCK SQL/Oracle setup script containing this trigger and sequence. Run the affected script through sqlplus, confirm it no longer hangs after the trigger definition, and verify the sequence is removed when the tables are dropped.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 38/100