Recent content by KaeOl

If you look at the download-page, you 'll find the requested password. ;-)

Yes, You can! Don't put Your date-parameters as string - this could make trouble in different language settings. The better way in handling date values is to use the built-in date-conversion functions. E.g. to_date ('08.03.2001', 'dd.mm.yyyy')

Before posting such questions please read the forum!! Look at this posting: http://www.allroundautomations.nl/ubb/Forum1/HTML/000594.html ------------------ Oliver Kaesmann

Have you checked the PL/SQL Developper from Allround Automations? That's a really great tool including debugging in procedures/functions/packages/triggers/.... Oliver

When installing DOA the menu item "Oracle" is added to your Delphy menu. The first entry in this item is the Package Wizzard. Oliver [This message has been edited by KaeOl (edited 04 January 2001).]

You can derive your own version of TOracleQuery where you overrides the Execute method where you check and try to reconnect. You onl yhave to replace all TOracleQuery instances in your project by your own Query object. Oliver

An other posibility may be: That won't raise an AV. Oliver

I think (but not really know) that calling LAST will only fetch the last few records of the table. All other behavior won't make sense ... Oliver

The easiest way to do is to use the Net8-Assistant tool delivered with Oracle to make an database-alias to the server connected via internet. There you specify the IP-address of your server. In the logon of your TOracleSession you set the Property "LogonDatabase" to the alias specified in...

Watch the topic "how to reconnect session" from 06 October 1999

You need not to feel like an idiot. What do you think why I knew this problem .... ------------------ Oliver Kaesmann

Hello Jay, are you sure, you've entered the password/username in the right properties in the object inspector? The sequence in objectinspector is changed as in the standard logon-dialog. Oliver ------------------ Oliver Kaesmann

You can check the availability of Oracle by using TOracleSession.CheckConnection. If connection has lost, you can use the method TOracleSession.Reconnect to reinstall the connection. ------------------ Oliver Kaesmann

Hy, Your ISAPI-dll starts an new thread for each reques, the server gets. If two different threads are using the same query-instance, thread2 overwrites information requested by thread1. The easiest way to solve this is to use one instance of TOracleSession, wich is created in the...

Your application have to be multi-threaded, becauce the thread, that executes the query is blocked while the query is running. So you do need an other, non blocked, thread who cancels the execution of the query. Oliver