Script error - Inserting multiple rows in one SQL statement.

[Former Member]

Hi,

Tried using INSERT ALL INTO command inside Script. But getting below error.

Oracle <> error message for operation <OCIStmExecute>: <ORA-00928: missing SELECT keyword>.

Same query with single insert statement runs fine without any issues.

Oracle eg:

INSERT ALL

    INTO item (title) VALUES ('title5')

    INTO item (title) VALUES ('title6')

    INTO item (title) VALUES ('title7')

SELECT * FROM dual;

Appreciate your suggestions.

Thx

[Former Member]

Hi Debasree,

Could you please split the INSERT ALL statement and check if they are working individually.

I see in the screenshot you are missing select * from dual; for first insert all statement. The error also suggests the same thing(Missing Select...)

Regards

Arun Sasi

[Former Member]

Thanks Arun,

As I mentioned before, if I split the command individually its working fine.

select * from dual is there in both statements.

Thought of using INSERT ALL to avoid multiple calls to db.