Recent content by Laurent Boutet

Hi all, we've just encountered the same issue here... We'd like to know if anyone has found a solution ? We tried 2 solutions : 1 - setting TOracleSession.Preferences.IntegerPrecision to 10 => ok with Oracle 9.2.0.7.......BUT NOT OK with oracle 9.2.0.1. The pb is that our customers have...

...and of course, it only works for created forms at runtime... Any other solution ?

well...in fact, the best way is to count this way : MyTOracleSession.Queries.lockList.count not DataSets.Locklist.count

finally, I found a solution that suits me : => I display MyTOracleSession.DataSets.lockList.count at runtime if equal to 0, no problemo for deletion :o ) I think it's a good solution, isn't it ? :o )

Hi all ! A very easy question : how to know all my TOracleDataSet & TOracleQuery connected to my TOracleSession ? :confused: I need to know because I want to delete a TOracleSession...but I don't know if it is still used by any TOracleDataSet or TOracleQuery Thanks in advance, Laurent

Hi ! Thank you for your help...but in fact, I've just solved my pb : When my service did not work well, i put the code in the OnCreate event of the service to connect to the database => the connexion hanged up when starting...but not when installing... Now i've just cut-past the same code to...

well...i am not used with enabling SQL Net tracing... I suppose i have to change the SQLTrace property of my TOracleSession to stTrue... and then ??? what do i have to do ? Thanks in advance, Laurent

Hi, i think someone had my pb, but no real answers were made : I made 2 project with the same code inside : In the create event, i just make a connection to oracle. If the connection is ok, it finally writes "ok" in a log, if not, it just writes "not ok". Here is the code ...

Hi, (a long time since i havent been posting something here ;-)) Here is the following error message i get when i try to connect : ================================ Initialization Error SQL *Net not properly installed OracleHomeKey: SOFTWARE\ORACLE OracleHomeDir...

hi ! I'm still french, and still with a french accent, so as usual, please forgive me. it's been a long time since i haven't been sending any question here...surely because DOA works perfectly ;-) So : I'd like to know if it is normal that DOA takes a lot of memory ? In fact I don't know if...

Hi, I'd like to know if I could use DOA components to shutdown.startup my Oracle DataBase. TOracleScript component can do such a thing ??? I just tried...but only could connect with the command : connect internal/***** And then, impossible to use shutdown... Any idea of how to do a shutdown...

Hi ! (haven't post messages for a while) I'm making a hot backup... I used to use a create process to launch a script to do that... But now, i'd like to know if it is possible with a TOracleScript... I tried to...but it doesn't seem to work. For instance, the folowing lines don't seem to work ...

Hi, here is a sample of my code that works (my blob is a gif file) : with qryRecupImage do begin SetVariable('vMYKEY', valClef) ; Execute ; if not LobField('MYBLOB').IsNull then begin qryRecupImage.LobField('MYBLOB').SaveToFile('c:\temp\toto.gif') ...

Hi, I'm french, so please forgive my french accent ;-) I'm a beginner in Oracle...I'm migrating my project from Interbase 6 to Oracle 8. And I use DOA... Could you please explain me the behaviour of DOA concerning CLOB. Indeed, I do manage using DOA with CLOB for inserting for instance...but I...