Member Avatar for veledrom

Hi,

How can i call a Oracle Stored procedure in vb6?

Stored procedure :

ADD_SP (1, '1', 1, 1, 'abc')

Thanks

  • 1 Contributor
  • 1 Reply
  • 135 Views
  • 17 Hours Discussion Span
  • Latest Post Latest Post by veledrom
Member Avatar for veledrom

Solved.

sqlFran = " Begin StorPro ( '" & DataGrid1.Columns.Item(0)& "' , '" & DataGrid1.Columns.Item(1) & "', '" & Form6.DataGrid1.Columns.Item(1) & "', '" & xValue & "' , '" & DataGrid2.Columns.Item(1) & "' ); End;"
    Set rcsetFran = conn.Execute(sqlFran)

Make an Adodc connection and
You can change the values according to your project.

Regards

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.