Problem in the insert statement

[Former Member]

Hi all,

I'm tring to insert data in Oracle table:

String sqlString = "INSERT INTO SAPFP1DB.PROVA2 (CAMPO1) VALUES ('quattro')";

Statement stmt = conn.createStatement();

stmt.executeUpdate(sqlString);

I have an SQL Exception:

The SQL statement "INSERT INTO "SAPFP1DB"."PROVA2" ("CAMPO1") VALUES ( 'quattro') " contains the semantics error[s]: - 1:22 - the table or view >>PROVA2<< does not exist

Now, the table exist in Oracle, in the right schema. All permission given!

Any solutions?? Thx,

Vito

[Former Member]

Hello Vito,

It is not possible to do insert into a view. It is possible to perform insert only to a table.

Check if you are connected to the right data base.

good luck

[Former Member]

Problem solved. Thx.

Vi.

[Former Member]

...on my own...;)

[Former Member]

Hi Vito, how did you solve your issue?

I have the same one in MS SQL Server 2005 and I don't know what to do...

Thx

Mattia