Call Oracle procedure from VB6

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ABHIJITghosh
    New Member
    • Sep 2007
    • 1

    Call Oracle procedure from VB6

    Hi,

    I like to call a procedure of oracle from VB 6.
    How can I do it?
    help me.
    Thank you.

    Abhijit Ghosh
  • QVeen72
    Recognized Expert Top Contributor
    • Oct 2006
    • 1445

    #2
    Hi,

    check this :

    [code=vb]
    Dim MyCmd As New ADODB.Command
    Dim RST As New ADODB.RecordSet
    MyCmd.ActiveCon nection = AdoCon
    MyCmd.CommandTe xt = "{CALL MyStoredprocedu re(?)}"
    Set RST = Nothing
    Set RST = MyCmd.Execute
    [/code]

    REgards
    Veena

    Comment

    • debasisdas
      Recognized Expert Expert
      • Dec 2006
      • 8119

      #3
      Please find the details of calling oracle stored procedure from Vb here.

      Comment

      Working...