This content has been marked as final. Show 3 replies
What is the insert statement you are using ? Can you show the full output shown in SQLPLUS ?
Edited by: mkirtley on Apr 26, 2013 10:06 AM
this is sql statement which I tray to run from toad:
INSERT INTO "URUNKART"@MERKEZDB(URUNKODU, URUNADI, SATISTIPI, KDV, FIYAT) VALUES ('TEST','TEST','MUHTELIF',8,10);
and this is the error I get;
ORA-02070: database MERKEZDB does not support insert values in this context
Hi,1 person found this helpful
MySQL is case sensitive for object names.
Was the table created with an upper case name - URUNKART - and were all the columns created with upper case names ? If not, then you need to write the name in the correct case as on MySQL and surround with double quotes, as in - "Urunkodu".
The other thing to checkis that you are using the correct datatype for the inserts.
What is returned in SQLPLUS for -
- do not put a semicolon at the end.
Could you get a 255 level trace from the insert and make it available, or at least the section where it indocates errors.
TO do this in the gateway init<sid>.ora set the trace to -
and run the insert from anew SQLPLUS session then end the session.