Re: Regarding SQL/PLus

From: Jeffery Cann <jcann_at_fairway.com>
Date: 1998/03/04
Message-ID: <34FDE75A.938691_at_fairway.com>#1/1

Hello.

The ORA-00911 error is 'invalid character'

Oracle does not allow you to use the following characters in a single quotation mark ' ':

$ _ #

You can use them in a colum name, but the must be enclosed in double quotes " "

>
> 1 INSERT INTO ANALYZED_SAMPLES VALUES( '0033', '01-DEC-58', '0000',
> 'ph_f', '5.00','');
> 2 INSERT INTO ANALYZED_SAMPLES VALUES ( '0033', '01-DEC-58', '0000',
> 'secchi', '', '' );
> 3 INSERT INTO ANALYZED_SAMPLES VALUES ( '0033', '01-DEC-58', '0000',
> 'w_t', '7.00', '');
>
> SQL> /
> INSERT INTO ANALYZED_SAMPLES VALUES( '0033', '01-DEC-58', '0000',
> 'ph_f', '5.00','');
>
> *
> ERROR at line 1:
> ORA-00911: invalid character

Make sure that you are entering this data into a varchar or varchar2 column,

for example, oracle will let you do this:

---

 1* create table jtemp ( text_column varchar2(30)) SQL> / Table created.

SQL> insert into jtemp values ('wt_t');

1 row created.

---

Good luck.
Jeff

-- 
Jeffery C. Cann
Senior Software Engineer
Fairway Systems, Inc.

Received on Wed Mar 04 1998 - 00:00:00 CET