Ampersand parsing problem with Oracle 8.1.6

Hi,

I am getting an error when I run the following lines of SQL statements using SQL*Plus
Worksheet. I am able to isolate the problem which is caused by the '&' in line # 4. If I
remove it from the line all the lines are parsed correctly and add data to the table.

Can someone tell me what is wrong with Oracle 8.1.6. I am trying to migrate from 7.x to 8i.
The script itself runs fine on 7.x as well as on Oracle 8.0.5.

Here is the script.

DELETE taxcostplanner;

INSERT INTO taxcostplanner VALUES(1, 'Base Salary', 0);
INSERT INTO taxcostplanner VALUES(2, 'Bonus/Profit Sharing', 0);
INSERT INTO taxcostplanner VALUES(3, 'COLA/G&S', 0);
INSERT INTO taxcostplanner VALUES(4, 'Utility Cost', 0);
INSERT INTO taxcostplanner VALUES(5, 'Housing Cost', 0);
INSERT INTO taxcostplanner VALUES(6, 'Education Cost', 0);

Table structure is:
ULTCPCODEID NOT NULL NUMBER(9)
SZDESCRIPTION NOT NULL CHAR(40)

ULSITENO                                    NUMBER(9)

Thanks

Sohail Shaikh Received on Thu Jun 22 2000 - 00:00:00 CEST