Ques:- How do I call oracle pl/sql stored procedure from vb6?
Asked In :-
Techvaria Solutions,
Right Answer:
To call an Oracle PL/SQL stored procedure from VB6, you can use the following steps:
1. Set a reference to the Microsoft ActiveX Data Objects Library in your VB6 project.
2. Use the following code snippet to call the stored procedure:
```vb
Dim conn As ADODB.Connection
Dim cmd As ADODB.Command
Set conn = New ADODB.Connection
Set cmd = New ADODB.Command
conn.ConnectionString = "Provider=OraOLEDB.Oracle;Data Source=YourDataSource;User Id=YourUsername;Password=YourPassword;"
conn.Open
With cmd
.ActiveConnection = conn
.CommandType = adCmdStoredProc
.CommandText = "YourStoredProcedureName"
' Add parameters if needed
.Parameters.Append .CreateParameter("param1", adVarChar, adParamInput, 50, "value1")
' Add more parameters as necessary
End With
cmd.Execute
conn.Close
To call an Oracle PL/SQL stored procedure from VB6, you can use the following steps:
1. Set a reference to the Microsoft ActiveX Data Objects Library in your VB6 project.
2. Use the following code snippet to call the stored procedure:
```vb
Dim conn As ADODB.Connection
Dim cmd As ADODB.Command
Set conn = New ADODB.Connection
Set cmd = New ADODB.Command
conn.ConnectionString = "Provider=OraOLEDB.Oracle;Data Source=YourDataSource;User Id=YourUsername;Password=YourPassword;"
conn.Open
With cmd
.ActiveConnection = conn
.CommandType = adCmdStoredProc
.CommandText = "YourStoredProcedureName"
' Add parameters if needed
.Parameters.Append .CreateParameter("param1", adVarChar, adParamInput, 50, "value1")
' Add more parameters as necessary
End With
cmd.Execute
conn.Close
