-
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, ATACURSOR); 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
Last edited by TO_raptor; 04-23-2003 at 12:32 PM.
-
-
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
-
Still awaiting help
Hi,
I still havent been able to get any resolution of this issue. Pls Help if possible
Thx.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|