OO4O: calling Stored proc from VB problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: OO4O: calling Stored proc from VB problem

  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 01:32 PM.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Dec 2001
    Posts
    26
    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

  4. #4
    Join Date
    Dec 2001
    Posts
    26

    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
  •  


Click Here to Expand Forum to Full Width