Seems there is an issue with Beta 24.1.113 and Fortnox when calling a stored table @inmemorystorage
inside a loop:
--
-- Case with DataDictionary : works!
--
create or replace table test@inmemorystorage
as
select *
from Calendar@DataDictionary
limit 10
select * from test@inmemorystorage
declare
my_query text;
begin
for r in
( select *
from test@inmemorystorage
)
loop
my_query := my_query || 'my text' || r.Day_In_Week;
end loop;
--
dbms_output.put_line(my_query);
end;
--
-- Case with Fortnox : raises itgensql151 error.
--
create or replace table accounts@inmemorystorage
as
select *
from Accounts@fortnox
where Active = true
;
select *
from accounts@inmemorystorage
declare
my_query text;
begin
for r in
( select *
from accounts@inmemorystorage
)
loop
my_query:= my_query || 'my text' || r.Description ;
end loop;
--
dbms_output.put_line(my_query);
end;
Error:
itgensql151:
Parse error on line 6 at column 42:
Unknown field or parameter ‘R.DESCRIPTION’.
Possible valid alternative symbol names: R.Description.
This issue is not raised in Invantive Cloud, see Faster way to retrieve account balances on Fortnox