Hi,

How can i call a Oracle Stored procedure in vb6?

Stored procedure :

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

Thanks

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