Question Re: Script error - Inserting multiple rows in one SQL statement. in Technology Q&A

Script error - Inserting multiple rows in one SQL statement.

Former Member — Wed, 08 Apr 2015 18:37:30 GMT

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 — Thu, 09 Apr 2015 07:23:33 GMT

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 — Thu, 09 Apr 2015 15:32:37 GMT

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.

Former Member — Fri, 10 Apr 2015 19:17:53 GMT

Any suggestions ??

Former Member — Sun, 12 Apr 2015 15:31:33 GMT

Hi,

Actual syntax is as below:

INSERT ALL

INTO suppliers (supplier_id, supplier_name) VALUES (1000, 'IBM')

INTO suppliers (supplier_id, supplier_name) VALUES (2000, 'Microsoft')

INTO suppliers (supplier_id, supplier_name) VALUES (3000, 'Google')

SELECT * FROM dual;

Now in your non working query, you have applied comma after first INTO statement.

Please remove it.

Thanks,

Swapnil

Former Member — Mon, 13 Apr 2015 18:49:35 GMT

Thanks @Swapnil. the query worked.