PowerBuilder 2019R3 b2703
Windows 64 bit platform
I have declared a FUNCTION in the PG database as follows:
f_cabs_glextract_master (vin_date IN character varying, session_id OUT character varying)
What I need to know is how to both DECALRE and to CALL this function from my PowerBuilder code. It's not in a DLL, it's in the database.
The goal is to run the function, then read the output variable "session_id" so I can use it in my PB code.
Note that for a stored procedure, this works; sqlcG is the transaction object connected to the PG database:
// Start the dynamic call to run the stored procedure
DECLARE seq_cursor1 PROCEDURE FOR sp_cabs_glextract_master
@vIn_Date = :ls_date
If sqlcG.SQLCode < 0 Then
ls_hdr = 'Error Calling Stored Procedure'
ls_err = 'Error running seq_cursor1(): ~r~n~r~n' + sqlcG.SQLErrText
<...... code ....>
// Close the cursor
IF (ls_err = "") THEN
cb_connect.POST SetFocus ()