Recent content by Cvarak

and again (repost?): it seems that min=0 triggers the problem...

forgot to add: object osp: TOracleSessionPool Max = 5 LogonUsername = '...' LogonPassword = '...' LogonDatabase = '...' end and TOracleSession: Preferences.MaxStringFieldSize := 255; Pool := SvcModule.osp; Pooling := spInternal; LogonUsername:='..' all "deafult"...

hi marco! i have serious problems with oracle/doa since a firewall between my server with doa and oracle db has been errected. new policy dumps the physical db connection between my host (with OracleClient) and db itself after 2h of inactivity. bad thing: no exception raises, pool "thinks"...

[/b] hi marco! thanks for a right way to get the version, i'll check it out. ad 1) yep i must get count(*) before dealing with a select, yet my question was: let's say i have , and getting the count(*) results with count=50,000. so, i don't want to show all 50,000 rows, but only row 32000 to...

hi marco! nice seeing you answer the questions posted! it seems like i have two, too: 1) i already looked for a kind of *limit* function in a select on the forum, but i'm not sure if i can use the aw. well, i am making a web interface for some oracle tables, and i would find it handy to "flip"...

hi again! thx for the prompt answer, cvarak

hello marco, short question: is SessionPool thread-safe and how do you gain the thread-safety? thx, cvarak

hi marco! it works perfect now. thx, cvarak

hi! due to the very intensive and performance critical functions using doa i came to the only possible solution for my performance issue = extending TOracleQuery. i know, normally i should inherit, yet it's hands on and i must use private objects from the query, (avoiding) encapsulation. i...