hello,
I tried to call this stored procedure in LibreOffice Base:
CREATE OR ALTER PROCEDURE myproc
RETURNS (val CHAR(100))
AS BEGIN
FOR SELECT "customer" FROM "test" INTO :val
DO
BEGIN
SUSPEND;
END
END
but I have the following error when I try to execute it:
*firebird_sdbc error: Cursor is not open caused by ‘isc_dsql_fetch’
I tested with this one:
CREATE OR ALTER PROCEDURE DUMMY
RETURNS (TXT VARCHAR(10))
AS
BEGIN
TXT='DOG';
SUSPEND;
TXT='CAT';
SUSPEND;
TXT='MOUSE';
SUSPEND;
END
I got the same error!
This is my LibreOffice Base file:
dbfirebird.odb
Any idea on how to solve this problem?
Configurations:
LibreOffice Version: 6.4.1.2 (x86)
Build ID: 4d224e95b98b138af42a64d84056446d09082932
CPU threads: 4; OS: Windows 10.0 Build 17763; UI render: default; VCL: win; Locale: fr-CH (fr_FR);
UI-Language: en-GB
Calc: CL