Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
No error in OO4O on session timeout? (Read 3396 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
No error in OO4O on session timeout?
28.04.08 at 18:15:07
 
No error in OO4O on session timeout?
 
Aparently there is no error occurring in OO4O (Oracle Objects for OLE) when a session timeout occurs. I have set a session timeout on the profile of the user account I am using. I know the timeout occurs as I am fetching 40,000 rocords and at the timeout I have not fetched all records. The strange thing is that no error occurs when the session times out. THe EOF on the dynaset is simply set to true...
 
The code I have used to test this is:
 
Code:
Public Sub test()
  Dim l As Long
  Dim ora As OracleInProcServer.OraServerClass
  Dim db1 As OracleInProcServer.OraDatabase
  Dim dyn As OracleInProcServer.OraDynaset
	
  Set ora = New OracleInProcServer.OraServerClass
  ora.Open ("ora10g")
  Set db1 = ora.OpenDatabase("gjlinker/scarry", 0&)
  Set dyn = db1.CreateDynaset("select * from all_objects", 0&)
  
  dyn.MoveFirst
  While Not dyn.EOF
  

    Debug.Print CStr(l) & " " & dyn(1).Value
    l = l + 1
    dyn.MoveNext
  Wend
End Sub
 

Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1