Recent content by indigo

I am getting an ORA-00942 error when I execute the procedure depicted below which uses TOracleDataset components. I am obtaining data from Table1, creating or updating a record in Table2, and then updating a value on the current record in Table1. The record is available and everything works...

New Database: AL32UTF8 Old Database: WE8MSWIN1252

I am converting to a new server but I am getting unexpected errors like: ORA-12899: value too large for column .. (actual 30, maixmum 2) on various fields when I try to insert records. I am using a TOracleDataSet with: select t.*,t.rowid from returns2 The program has been in use for many years...

Hello: I have had a problem for the past few days where PL/SQL Developer either hangs at startup or crashes afterwards. The program hangs after entering the password for the database. The last phase displayed in the startup windows varies. By cancelling the initial connect password, the...

Marco: The original message here was posted on October 17. It is now November 8th and I still don't have a solution. The problem occurs under Vista with Delphi 2007. Thanks, Sidney

Marco: I have more information for you. The problem occurs after I restart my computer and run Delphi. If I try to access any form or data module with DOA components, Delphi stops with the message: "Codegear Radstudio for Windows has stopped working". Restarting Delphi makes no difference...

This problem has not been resolved. Are you making progress on it? Thanks.

The installation notes say "Delphi 2007 for Win32 (Update 3). Other than that, I am not sure how to find out what update I have since I can't find the release notes or other references to the version. The help folder has the following: Log File: C:\CodeGear\RAD...

My database is remote via a VPN connection. This worked to get me in: Shutdown computer and restart. Start Delphi 2007. Established VPN connection. File/New VCL Forms Application Dropped Session component and waited. Set Logon information and Connected=True. Opened the application I want to...

After installing the the version 4 upgrade to Delphi 2007, I get the message: Codegear RAD Studio for Windows has stopped working. A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available. Debug / Close Program This...

Marco: I don't understand what you mean by I cannot use a TOraclePackage to do this. I am already doing it and it works fine except oracle only receives the first 4000 bytes. It is as if it is ignoring the clob definition and treating it as varchar2. I am not interested in returning the CLOB...

Hello: I have an Oracle package which implements a number of functions for a webservice. The SendReturns function of the package is used by the webservice to deliver XML via p_ReturnsData which is stored in a CLOB in the database. A TOraclePackage(EServicesPackage) is used to access the...

That worked fine. I only need this when there are too many records in the lookup database to use a TDBLookupComboBox. I am currently converting one of my large applications to Oracle. Is there no other way to accomplish this which does not require dropping queries, etc.?

Marco: I think I followed the example, but it does not work properly. The key changes I made are: I double clicked my TOracleDataSet and made everything persistent fields. I changed the type on my TaxpayerName field to fkCalculated, changed its Origin to Taxpayers.TaxpayerName, and changed...

I have the following SQL: select visits.*, visits.rowid, accounts.name from vists,accounts where visits.AccountNo = accounts.AccountNo When the DBText for accounts.name is displayed for existing records, everything is ok. When I insert a record, the DBText field is blank. What method can...