DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: OO4O: calling Stored proc from VB problem

Threaded View

  1. #1
    Join Date
    Dec 2001
    Posts
    26

    Question 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width