Reputation: 141
I am running a script in sql*plus, it's located in the Desktop and my command is:
@C:\users\intel\desktop\script1.sql
When I press enter key, the pointer just go to the next line and blink there and then nothing is done. Even I can't write anything. What's the problem??
This is the part of my script:
CREATE TABLE ADDRESS
(
ADDRESSID INTEGER PRIMARY KEY,
FLAG CHAR(1),
ID INTEGER NOT NULL,
ADDRESS VARCHAR(100)
);
CREATE TABLE Category (
CategoryId INTEGER NOT NULL ,
CategoryName VARCHAR(100) NULL,
PRIMARY KEY(CategoryId)
);
Upvotes: 0
Views: 18422
Reputation: 424
You may have had a pending transaction. Try to commit / rollback your transactions and run your script again.
Upvotes: 0