Calling function with OUT-Variable

[SebastianWeissJW]

Hi,

maybe i am just stupid but i cant figure it out, when i call a plsql-procedure that has an OUT-Variable like this:
call sender_update(10,'19','4443',msg.payload)
i get the following error:
Oracle query error: ORA-06576: not a valid function or procedure name, errorCode:ORA-06576
when i try without "call" i get:
Oracle query error: ORA-00900: invalid SQL statement, errorCode:ORA-00900

this is the header of the procedure:
CREATE OR REPLACE PROCEDURE sender_update
(
p_sr_id IN INTEGER,
p_sr_transponder IN VARCHAR2,
p_sr_eingabe IN VARCHAR2,
p_sr_info OUT VARCHAR2
)

i try to get the OUT-Variable to go into msg.payload to keep working with the return value. so basically, what i am asking is, how do i "catch" the value of this OUT-Variable or is that not possible?

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• OS: Windows 11 x64 22H2
• Browser: Opera
• Node-RED v2.2.2