Boolean in ADO command against Oracle PL/SQL procedure

From: Robert R. Wagner <r.r.wagner_at_ieee.org>
Date: Tue, 16 Nov 1999 18:10:49 -0500
Message-ID: <%xlY3.19594$YI2.848394@typ11.nn.bcandid.com>

I'm having trouble using ADO with Microsoft's OLEDB provider for Oracle. I'm trying to pass a boolean to an Oracle PL/SQL procedure. Here's the call:

Set cmdadoUpdate = New ADODB.Command
With cmdadoUpdate

.ActiveConnection = gcnADO_OrUnidat
.CommandText = "PKMAIN_SUBS.UpdateSubJobDate" ' The path to the
completion date update procedur

.CommandType = adCmdStoredProc
.Parameters.Append .CreateParameter(, adVarChar, adParamInput, 5, MyTest)
.Parameters.Append .CreateParameter(, adVarChar, adParamInput, 8,
Me.ctlMainJob)

.Parameters.Append .CreateParameter(, adVarChar, adParamInput, 15,
Me.ctlSubJob)

.Parameters.Append .CreateParameter(, adBoolean, adParamInput, 1, True)
.Parameters.Append .CreateParameter(, adNumeric, adParamOutput) 'Number
updated (should be 1)

.Execute

End With

---

Here's the specification for the procedure in the Oracle package: PROCEDURE UpdateSubJobDate (mainNumber IN VARCHAR2, subNumber IN VARCHAR2,testtype IN VARCHAR2, flgSet IN BOOLEAN,intaffected OUT NUMBER);

The error message is "PLS-00306:Wrong number or types of arguments in call to UpdateSubJobDate."

I vaguely recall that Oracle's and Microsoft's idea of a boolean are different. Can anyone help me here?

TIA >>>>>> Robert

ExpanTest, Inc.
22 Monument Square, Suite 503
Portland, ME 04101-4031
http://www.gwi.net/expantest
(207) 871-0224 Received on Tue Nov 16 1999 - 17:10:49 CST