Recent content by ltd

Hi, i have a strange crash when using the oracle dataset. Oracle server 10.2.0.1.0 Oracle Client 10.2.0.1.0 DOA 4.0.6 I have produced a reduced test: I have a dataset with a valid SQL statement and a button with the following code: { data->Active=false; data->Active=true; } The following...

One other thing i saw in your example code: AnsiString OCIDLL = "C:\\ORA32\BIN\\OCI.DLL"; Here is a backslash missing. It should be "...\\bin..." Lars

Hi, there is a constructor for TOracleSession: pPrjOraSession = new TOracleSession(NULL); As with all components it has one Parameter which is the owner. Lars

I have checked my variables again and the only additional thing is that i have the /home/oracle/lib in the path also. By the way i think that you made only a typing error with "LD_LIBRARY_PATCH" there is an extra "C" in what you posted here. Yes Kylix needs some Patches but it is still a...

I had to add the Oracle library path to the LD_LIBRARY_PATH= Variable to get console applications to work with oracle. Lars

Hi, i have to test Kylix3 (C++ ide) so i tried to install the DOA 4.0.3. This tells me that my registration key is not valid ( OK button is disabled) but my registration should allow me to use a version 4. After that i installed DOA 3.4.6. That seemed to work. There are components which i can...

Hi Marco, another missunderstanding due to my example not beeing clear enough. The code in my previous mail is in the constructor. After that you only find something like this ( code comes from another query) : pqDestReq->SetVariable( "nIDOperator", GlobalOperator.GetUserId())...

Hi, there was one ":" missing in the example. Here is the real code: pqPeerState->SQL->Add( "BEGIN" ); pqPeerState->SQL->Add( ":nRet := "+asPackageName+"PEERSTATE( :nIDInstance, :nIDOperator, :tBitPos," " :tBitValue, :nSize...

Hi, i have the following problem. When i use a TOracleQuery to execute the following code i get parses on the database for every call. "begin Return:=Mypackage.Myfunc(:Par1,:Par2); end;" When i call the following code i get no extra parses: "begin MyPackage.Myprocedure(:Par1,:Par2,:Par3)...

Hi, the solution to your problem looks something like that in c++ bool bFinished=false; while(bFinished==false) { try { SQLVar.Execute(); // some more code bFinished=true; } catch( Exception &E) { // Some error loggin first // if(SQLSession->Connected==false)...

Hi, the following code functions without any problem within a TThread constructor: SQLSession=new TOracleSession(NULL); SQLSession->LogonUsername=GlobalIniFile.ReadString("DATABASE","USER",""); SQLSession->LogonPassword=GlobalIniFile.ReadString("DATABASE","PASSWORD","")...

Hi, we tried to use the Transparent application failover feature from oracle with DOA 3.4.5 on BCB5. But when we made the tests with a TOracleDataset we got the following error codes from oracle. 1: ORA 01023 cursor context not found 2: ORA 25408 cannot safely replay call Is there anything we...

Hi, what did you try to make the test ? Did you use a TOracleQuery or a TOracleDataset ?? With an TOracleDataset you should look at "QueryAllRecords" property. If it is set to true you have a different behavior then with BDE. So if you realy want to see the pure DOA speed you should try...

Hi, there is also another advantage for DOA. The load on the server is much lower then with BDE. for example if you have two DBgrids displayed as master/detail relation and scroll in the master table i did some tests. Every time i scrolled in the same amount of data. All numbers show values...

On our database we set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 in all the Oracle home entries on the client and all the Umlaute show up in our applications. Lars