Problem with TOracleScript

[Damo]

I have a problem with converting defined Varialbles in TOracleSript-component.
Please see example:

DEFINE UsrFrom = USER1

DEFINE UsrTo = USER2

insert into USER2.tb_price(id,shop_id,day_of_week)
(select &UsrTo..seq_price.nextval,shop_id,day_of_week
from USER1.cvt_pagamenti)

ORA-00923: FROM keyword not found where expected

commit

/***************************************************************************/

That was the original SQL statement

/***************************************************************************/
insert into &UsrTo..tb_price(id,shop_id,day_of_week)
(select &UsrTo..seq_price.nextval,shop_id,day_of_week
from &UsrFrom..cvt_pagamenti);
commit;

 

[Marco Kalter]

This is a known problem that is fixed in the upcoming 3.4.4 patch release. Identical substitution variables will currently only be replaced once in a single command.

------------------
Marco Kalter
Allround Automations