How do I get PL/SQL developer to handle a script file. I am currently using the SQL Script window and it keeps failing. SQL Plus does not choke on my file format and I am using legal syntax. Here is part of my script file that keeps choking... Is the SQL window for standalone scripts?
CREATE TABLE REGIONS (
REGION_ID NUMBER NOT NULL,
REGION_NAME VARCHAR2(25) NOT NULL
)
/
INSERT INTO REGIONS VALUES(1, 'Europe')
/
INSERT INTO REGIONS VALUES(2, 'Americas')
/
INSERT INTO REGIONS VALUES(3, 'Asia')
/
INSERT INTO REGIONS VALUES(4, 'Middle East and Africa')
/
CREATE TABLE REGIONS (
REGION_ID NUMBER NOT NULL,
REGION_NAME VARCHAR2(25) NOT NULL
)
/
INSERT INTO REGIONS VALUES(1, 'Europe')
/
INSERT INTO REGIONS VALUES(2, 'Americas')
/
INSERT INTO REGIONS VALUES(3, 'Asia')
/
INSERT INTO REGIONS VALUES(4, 'Middle East and Africa')
/
