Q: First call to stored procedure via ODBC

Hello.

Does anyone know why it takes so long (sometimes over a minute) to call an Oracle Procedure via ODBC the first time? The second and subsequent calls return quickly. We are using Oracle's ODBC driver.

' Example (VB) - procedure in a package with "NULL" body

    Dim Cntr As Long
    lstStatus.Clear
    AddRow ("Connecting to the database")     Set dbJIMMTEST = OpenDatabase("", False, False, "ODBC;")     AddRow ("Connected to the database")     AddRow ("Calling procedure first time")
' Can take over a minute

    Cntr = dbJIMMTEST.ExecuteSQL("begin corp_actions.corp_null; end;")     AddRow ("End call to procedure")
    AddRow ("Calling procedure second time")
' Usually less than two seconds

    Cntr = dbJIMMTEST.ExecuteSQL("begin corp_actions.corp_null; end;")     AddRow ("End call to procedure")

Thanks in advance

Benjamin Bielak
WearGuard
dover_at_world.std.com Received on Thu Aug 24 1995 - 00:00:00 CEST