Re: Ampersand parsing problem with Oracle 8.1.6

Add
set scan off
prior to the first insert.
I tested your code and had the same problem in 8.1.5 Given the fact the & is used for substitution variables since the early days of sql*plus in 1989, it is IMO a bit difficult to believe you didn't encounter this problem in 7.3 and 8.0.5
Anyway.

Hth,

Sybrand Bakker, Oracle DBA

"Sohail Shaikh" <sohail.shaikh_at_starpower.net> wrote in message news:8iteag$bf1$1_at_bob.news.rcn.net...
> 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);
> COMMIT;
>
> Error I am getting is:
> Lines are mixed up starting from 'COLA/G&S' and are misleading.
>
> ERROR at line 1.
> ORA-00917: missing comma
>
> 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