how to create insert command in native SQL?

[t4nu]

Hi,
I have to use the native SQL to fetch data from table, retrieving the table data is not a problem, the problem is when I want to add new record or update existing record.
I understand that I have to put the INSERT command or UPDATE SQL command, but I confuse what parameter should I use as the parameter in the values part.
Here what I mean:

Code: Select all

INSERT INTO <myTable> &#40;field1, field2, field3&#41; VALUES &#40; --- this part confused me --&#41;;

I have tried using VALUES (:field1, :field2, :field3), but it gave the error message:
....Missing IN or OUT parameter at index:: 1

and when I change the : to && it gave the error:

ORA-00933: SQL command not properly ended

(I have no problem when inserting new record using sqlplus or SQL developer using the same syntax).

[Segi]

the correct syntax is

INSERT INTO myTable (field1, field2, field3) VALUES (&&field1,&&field2,&&field3);

You also have to create the resource fields below by clicking on the green plus and adding the fields so for example, you'd add field1 and select its type if it is not the default varchar type.

[t4nu]

Hi,
Thanks for the respond.

As I said in my previous post, I also have tried that but it gave me an error:

ORA-00933: SQL command not properly ended

Seeing the error I thought it would be the problem with database, but when I tried to copy the command and paste it to the sql developer or sqlplus, it can run without problem.

the correct syntax is

INSERT INTO myTable (field1, field2, field3) VALUES (&&field1,&&field2,&&field3);

You also have to create the resource fields below by clicking on the green plus and adding the fields so for example, you'd add field1 and select its type if it is not the default varchar type.

[Jon]

Remove the semicolon at the end.

[t4nu]

EXCELLENT!!!
Thank you very much, Jon.

Remove the semicolon at the end.