Hi all,
When I try to open a session on an oracle database using the pl/sql procedure session#.open_s ession, i get the following error:
Run-time error '-2147467259 (80004005)':
Unspecified error
The code is as follows
Dim cmd as ADODB.Command
Set cmd = New ADODB.Command
WIth cmd
.CommandText = "session#.open_ session"
.CommandType = 4
.ActiveConnecti on = cn
.Execute
End With
...the connection (cn) has been set and everything. I can execute SQL queries for example. The error occurs on the .Execute
Any ides anyone?
Thanks in advance,
Fabalicious
When I try to open a session on an oracle database using the pl/sql procedure session#.open_s ession, i get the following error:
Run-time error '-2147467259 (80004005)':
Unspecified error
The code is as follows
Dim cmd as ADODB.Command
Set cmd = New ADODB.Command
WIth cmd
.CommandText = "session#.open_ session"
.CommandType = 4
.ActiveConnecti on = cn
.Execute
End With
...the connection (cn) has been set and everything. I can execute SQL queries for example. The error occurs on the .Execute
Any ides anyone?
Thanks in advance,
Fabalicious