I'm trying to build a NTservice that checks the contents of an Oracle DB. Via a thread (class TThread) i want to be able to check different DB's/schema's at the same time! How can i provide for a thread-session! (I'm a bit new to this thread stuff...) At the moment it seems that the first access is the one that gets the DB...

I'm not sure if what i just wrote is all clear to outsiders...

If you want to access different databases from different threads simultaneously, you should create a TOracleSession instance within the thread, and free the session when the thread is finished. The same goes for any TOraclyQuery and other instances you want to use.

If each thread has its own session, you don't have to worry that threads block eachother at the session level.

If you need many queries, you can create a data module at design-time, and create a data module instance at the thread level instead. It is of course much easier to setup your components at design-time than at run-time.

Thanks for the confirmation of my own ideas...

But there comes the problem.
I'm not really into this sort of techniques!
I've 'stolen' from the InterNet the TThread programming, but i can't find anything (yet) over instanciating a datamodule on tue TThread unit!

[quote]Originally posted by PirIS:
Thanks for the confirmation of my own ideas...

But there comes the problem.
I'm not really into this sort of techniques!
I've 'stolen' from the InterNet the TThread programming, but i can't find anything (yet) over instanciating a datamodule on tue TThread unit! [/quote]There is absolutely NOTHING SPECIAL. Just put constructor of DataModule into the Thread constructor. Delphi help contains more then enough information for working with threads. And several demo programs are supplied. Just take a look on them.