Good Morning,
I have the following code:
Dim oraCon As Object
Sub Main
openOracle("DB_LOC")
stmt = oraCon.prepareCall("VARIABLE x REFCURSOR DECLARE V_Sqlstatement Varchar2(2000); BEGIN V_Sqlstatement:= 'SELECT * FROM DUAL'; OPEN x for v_Sqlstatement; ?:=x End;")
REM Whate do i put here?
stmt.registerOutParameter(1, ????,????)
rs=stmt.executeQuery()
End Sub
I am trying to find out what I should put in the registerOutParameter
The call expects XOutParameters, where the 2nd parameter is a DataType constant.
A complete example is given by user rodolfo at https://forum.openoffice.org/en/forum/viewtopic.php?t=41149.
EDIT:
Multiple results are explained at https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1sdbc_1_1XStatement.html#ace0d6b1f30106a88de49a775ab275436: