user1844205
user1844205

Reputation: 141

SQL*Plus script hangs

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

Answers (2)

Etsitpab Nioliv
Etsitpab Nioliv

Reputation: 424

You may have had a pending transaction. Try to commit / rollback your transactions and run your script again.

Upvotes: 0

Mehmet Balioglu
Mehmet Balioglu

Reputation: 2302

Type / and press enter.This will run the command buffer

Upvotes: 1

Related Questions