ADO: open session in pl/sql

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Fabalicious
    New Member
    • Sep 2008
    • 1

    ADO: open session in pl/sql

    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
Working...