Error: ORA-00911: invalid character

Question

This is query when run from TOAD works perfectly, but when I run from the Visual studio give me the error 'ORA-00911: invalid character'. This is how looks my query:

INSERT into TRB (ID, ID_REF, DATE, STATUS, INSERT_DATE,
                           ID_DD_REF, USER, VERIFY_DATE, VERIFY_USER) 

select 11, 337470,
       to_date('22.11.2016','DD.MM.YYYY'),
       'O',
       CAST(TO_TIMESTAMP('2016-11-22 14:28:24.260','YYYY-MM-DD HH24:MI:SS.FF9') AS DATE),
       8552,
       'test',
       NVL(CAST(TO_TIMESTAMP('','YYYY-MM-DD HH24:MI:SS.FF9') AS DATE),''),
       '' from dual  
WHERE NOT EXISTS (SELECT ID FROM TRB WHERE ID = 11);

I am running from VIsual Studio 10 and progam is in vb code. — SeaSide, Dec 07 '16 at 11:35

score 5 · Accepted Answer · edited May 23 '17 at 11:45

5

Try removing the semicolon ; at the end.

Also, look at this question: Where's my invalid character (ORA-00911)

edited May 23 '17 at 11:45

Community

1
1

answered Dec 07 '16 at 11:25

Phylyp

1,659
13
16

1

That was the problem. Thank you a lot. – SeaSide Dec 07 '16 at 11:35

Error: ORA-00911: invalid character

1 Answers1