There are some subtle differences in the SQL between, say SQL Server select statements and the ones in Oracle. For instance, Oracle does not like join statements and prefers to use the table joins in the where clauses like '+='.
'Assuming you have a valid connection object 'cn', your ado
'command object needs a few more properties identified:
Set cmd = New ADODB.Command
Set cmd.ActiveConnection = cn
cmd.CommandText = "sp_YourSproc"
cmd.CommandType = adCmdStoredProc
cmd.CommandTimeout =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.