Recent content by Fabian

it works. thx!

We have a PC with two oracle-clients, one with release 8.1.7 and the other with 9.2. Our programm, which has Direct Oracle Access needs to connect to the server by the client 9.2, but it only "see" the oracle client 8.1.7. The oracle home points at 9.2. Is this a problem of direct oracle access...

Hello Marco Thank you for your answer. I have another question: How can I get the Error number in the OnError event? Thank you.

Hello I wanted to write an exception-handler in Delphi with DOA. I implemented a central Exception-procedure: Application.OnException := AppException; What I wrote is: with DataModule1.oscUserEdit do try Lines.Clear; Lines.Add('ALTER USER "'+dbedLoginName.Text+'"')...

Hello I want to use the TOracleScript Component for this script: COPY FROM MYSCHEMA/HELLO@TESTDB TO MYNEWSCHEMA/HELLO@TESTDB REPLACE MYTABLE USING SELECT * FROM MYTABLE; In the SQL*Plus Worsheet the Script works fine, the table is copied in the new schema. But the TOracleScript Component...

Hello Marco Thats exactly what I searched. Thanks a lot.

Hello I'm new with DOA. I have following problem: In a DataSet I can Set the property SQL. There I use Variables. "SELECT * FROM MYSCHEMA.MYTABLE WHERE MYTABLE.ID=:V_ID" But I have to change the Schema during runtime. The Tables are all the sames in all Schemas (History) So I need something...