Recent content by Eric^2

There is no way to get the password from the OS as that would be VERY insecure. If the Oracle client is loaded on the local machine, transparent authentication can pass the SID of the currently logged on user to the Oracle server for validation.

Is the table defined with a LONG column (depreciated) or has it been changed to a LOB (or CLOB or BLOB) column?

I may need to port an application (C/S DOA+Oracle 9i) to Oracle Lite and was wondering what all I'd need to change on the client. It's pretty simple, uses no stored procedures or functions, and weighs in at around 200MB. How does DOA work with Lite, and would you recommend an alternative...

Also list what naming method(s) you're using. If you're using hosts naming, then please provide the nslookup times for the host as you may be running into a DNS name resolution problem.

I just completed an Oracle 9.2.0.1.0 install (the latest on Windows) and tried this again. I still get the same error. Can anyone else verify this?

OracleLogon1.Options := OracleLogon1.Options - [ldAuto];

For you, the price is $25...

Until the next version of DOA is released, I subclassed the TOracleDataset component and added the ability for column comments to be pulled from the data dictionary. Set the QueryTable property to the query table or view name. Set QueryDictionary to True and open the dataset. The component is...

Just FYI... An index-organized table stores the values of the rows inside the index (on the primary key). Adding or removing items from the table causes the index to re-balance, thus invalidating the rowid. Index-organized tables will not work with DOA's TOracleDataset using ROWID's to update...

...and just so you can see it's a final/not final problem, do this: SQL> alter type taddress final cascade; Type altered. SQL> Try the above code again and it will work just fine. The crash occurs in orageneric9.dll during a read of address 00000010. Help.

This bug relates to accessing the properties of a nested object that is not final. Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production JServer Release 9.0.1.1.1 - Production SQL> create type taddress as object ( 2 line1 varchar2(30), 3 line2 varchar2(30), 4...

Try it again, and when you get the row id, open up SQL Plus and execute the following: select * from IMS_MARCA where rowid = 'THE ROW ID HERE' and see what you get. Chances are the rowid has become invalid. When DOA loads an editable result set into memory, it loads the row id's with it and...

As usual, fat fingers got me again... I was building the object based upon two tables and an INSTEAD OF trigger. I typed 'Coty' instead of 'City' into the view.

Oracle type tperson contains a name and address properties. Oracle type taddress contains a city property. APerson := TOracleObject.Create(blah); APerson.SetAttr('Name') := 'Eric'; AAddress := APerson.ObjAttr('Address'); AAddress.SetAttr('City') := 'Cleveland'; // Fails not finding City. I...

I don't know how applicable this is, but look here... http://uisnt1.humboldt.edu/otn/library/support/reports/network/content/486343.htm