Recent content by jestep

I spoke too soon it seems.... Somewhere along the line sessions are not getting disconnected. So I end up getting too many sessions error from Oracle. I can hit refresh 100 times on the browser and it works fine... I can see in my log that half of these get processed around the same time...

Uh huh..... I know that, but apparently the older version did not require this... But I have always freed my sessions at the end of the HTTP request, but with this version it causes a hang, I assume from using a session that was being freed. Anyway, I added in SessionPool.Release for each...

Ok, here it is: I have an HTTP server using DOA 3.4.6.4 and using pooling of spInternal... I create sessions withing the thread. If I have connections one at a time everything is fine, but once multiples hit things hang. I have one master Oracle Session... Can someone so me an example or tell...

Is it possible to get the entire list from you??

Thanks Marco, It is not in the documentation I have. Is there a new Version?. If not, when?? Still no columns that are char get returned as Char...... Now, they get returned as nothing. What is wrong here?? Function TfrmDescribe.ReturnFieldType(oType : Integer) : String; Begin Result :=...

When doing a describe using 3.4.6 Delphi 6... A char field is always being returned as otString instead of otChar.... Any ideas??

Thanks Marco, That should help me a lot.

I am using Ora 8.0.5 and IIS4 I am trying to use the internal pooling. I create a "Master" session and set pooling to spInternal. I then create other sessions on the fly. If Oracle is killed and restarted I receive Ora-12571 or Ora-01041 errors. When I receive these I disconnect the "Master"...

Hi Marco, Any word on DOA with Kylix?? Kylix is released this month, so I thought you might have a better idea now. Thanks

I hope there's a better solution.... Thanks for the help anyway...

Thanks for the response but, userenv('SESSIONID') "Session ID" actually gives you the AUDSID not the SID from v$session. I need the SID....

How can I get the SessionID from Oracle If the connected user does not have access to v$session??

You have to set the NLS_DATE_FORMAT in the registry on the client or you need to put an "alter session set nls_date_format='yyyymmdd'" in your apps right after the connect

Yes I know about that, but I was interested in doing some debugging myself....

Is there a way to debug a procedure using DOA???? Including Variable values, etc.