OO4O: calling Stored proc from VB problem

Hello,
In this call I make to test stored procedure to see if my OO4O works .. i get this error in Vb

"Method 'createSql' of object '_IOradatabase' Failed"

while the code is at this line..

Set oraCommand = _
.CreateSql("Begin LoadRowDataPack.LoadRowData(:FormID, :TemplateID, :TABNames, :TABIDs, :DATACURSOR); END;", ORASQL_FAILEXEC)

Note: in the parameters the TabNames and TabIDs are paramarrays defined as:

.Parameters.AddTable "TabNames", ORAPARM_INPUT, ORATYPE_VARCHAR2, UBound(strTabNameArr), 100
.Parameters.AddTable "TabIDs", ORAPARM_INPUT, ORATYPE_NUMBER, UBound(strTabIDArr), 100

And the Datacursor is:

.Parameters.Add "DATACURSOR", 0, ORAPARM_OUTPUT
.Parameters("DATACURSOR").serverType = ORATYPE_CURSOR

The rest are as:

.Parameters.Add "FormID", intFormUID, ORAPARM_INPUT
.Parameters("FormID").serverType = ORATYPE_NUMBER
and so on...

Please advise as to where the error may be coming from..

Thanks

Raghu

http://osi.oracle.com/~tkyte/ResultSets/index.html

Hello,
Thanks Jeff for your reply but i couldnt quite figure out how to resolve my problem as the link did not address my problem directly.

Please advise

Thanks

Hi,
I still havent been able to get any resolution of this issue. Pls Help if possible
Thx.