Recent content by jimpoe

Hi, There was a previous Oracle server installation that was not uninstalled completely. We uninstalled the current Oracle client, deleted anything left over and reinstalled the client. It now works. Thanks.

This is bazaar. function TAMSBusinessServer.DBNameIsValid( const DBName: WideString): WordBool; begin Result := OracleCI.OracleAliasList.IndexOf( UpperCase( DBName )) -1; end; This function is failing on a single W2K machine located at one of our customer sites. The OracleAliasList is...

Hi, ResolveToDataSet is False. This may not be a DOA issue. Looking further, I found this: I have a master/detail on my DataSnap appserver. When I do an insert into the master, the primary key column contains a value that was populated on the client. During the resolving of the sql in...

DOA 3.4.6.1 Delphi 7 Oracle 8.1.7.4.1 I am using many OracleDatasets in a datasnap server. I have a few datasets that are generating the wrong insert SQL. The select is 'SELECT A.*, ROWID FROM PUBDOC_CAT A ORDER BY RANK' It returns 5 columns, no LOB type. We populate the key column with a...

This is embarrassing. With a returned cursor the test window does not return the data until you open the parameter's dialog. The duration times are now equivalent between the dataset and the test window.

I am calling a stored procedure from an OracleDataSet. The stored procedure returns a cursor. When it is called from an OracleDataSet it is taking 2 minutes or more. When I run the same call from a PL/SQL Developer test window it takes 1.2 seconds. My test app is a form, an OracleSession...

You would probably find your answer on borland.public.datasnap. You could get the generated value by querying the database in the AfterUpdateRecord event and setting poPropagate changes to True on the DataSetProvider

When I run a script in the Command Window with 'set newpage none' I get the error, 'cannot set newpage' Why is this? Thanks

The old client was purged from the system and the same path was used for the new client. I finally rebooted the server which fixed the problem. It did not seem like a path problem since the dll's were all loading. Thanks for your help.

Hi, I'm running a Delphi 5/Midas/Direct Oracle Access/Oracle 8.1.7 environment. I have a W2K server with Oracle 8.1.7 installed. I have an NT 4 SP6 machine that had Oracle 8.1.5 installed. I had my MIDAS Appserver on the NT machine connecting to the 8.1.7 database on the W2K machine. This...

I don't think that is it. I tried using an intermediate string variable and still get the garbage. S := Value LOB.Write( PChar( S ), Length( S ));

I'm sure it is the way I'm using it but why doesn't this work? Value is a Widestring and contains RTF text. When debugging, Value contains the proper value. I'm using an update statement in an OracleQuery component. procedure TAMSBusinessServer.SetQuoteTermCond(QuoteId: SYSINT; const...

Thanks

I have noticed that PL/SQL Developer is always able to recompile all invalid objects. We are trying to find a method to compile all invalid objects after a customer site installation of our application database. We always end up with invalid objects. If it is not a trade secret, what kind of...

How do I set the documentation location in PL/SQL Developer. I moved it to the network and PL/SQL Developer is looking on drive C:\