Re: Ampersand parsing problem with Oracle 8.1.6

run the command "SET DEFINE OFF"
before running the "INSERT"-statements

Sohail Shaikh wrote in message <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 Mon Jun 26 2000 - 00:00:00 CEST