Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Dim connection
Set connection = createobject("ADODB.[b]Connection[/b]")
connection.[b]Open[/b] connectionString
Dim cmd
Set cmd = CreateObject("ADODB.Command")
cmd.ActiveConnection = connection
DIM RS
SET RS = CreateObject("ADODB.recordset")
cmd.CommandType = 4
cmd.CommandText = strProcedure
'Execute the stored procedure
[b]Set RS =[/b] cmd.Execute
connection.Close
The stored procedure I am trying to execute is not saved in Database (SQL Developer).
I am passing the stored procedure in the external excel sheet, then fetching the stored procedure in uft by making connection with the excel sheet.