Hello!
I need help because i have to use a stored function that returning a record type, for example:
CREATE OR REPLACE PACKAGE Pck AS
TYPE Rec AS RECORD
...
END;
FUNCTION Proc (p_in IN NUMBER, p_out OUT VARCHAR2(5)) RETURN Rec;
END Pck;
CREATE OR REPLACE PACKAGE BODY Pck AS
FUNCTION Proc (p_in IN NUMBER, p_out OUT VARCHAR2(5)) RETURN Rec IS
BEGIN
...
END
END Pck;
And a fragment
VB:
Set cmd = New ADODB.Command
With cmd
.ActiveConnection = connLocal
.CommandText = "Pck.Proc"
.CommandType = adCmdStoredProc
.Parameters.Append .CreateParameter _
("in",adInteger,adParamInput, ,data)
.Parameters.Append .CreateParameter( _
"out", _
?????? :(, _
adParamReturnValue)
.Execute
End With 'cmd
Set cmd = Nothing
I don't know that type data to use, can you help me?
Thanks.