Recent content by michaelbell

Thanks for reply. I did, as you suggested. The book now shows up in the list after rebuilding the index. But it's not used for searching when I activate it. Looking in subdirectory \Books of PL/SQL Developer shows up several index files with a size of 0 bytes. "Book34.idx" is one of them and the...

Searching in HTML manuals is very handy. But looking through the list of books, I can't find the "Oracle Spatial User's Guide and Reference". It's in the Oracle HTML manuals in subdirectory \appdev.920\a96630. Is there a way to add this book to the PL/SQL Developer HTML Manuals by hand?

That was exactly the example I wanted. Many, many thanks!! There seems nothing left, you can't do with DOA... :D

Please, back to the topic. I never said I wanted to update through a TOracleDataset. Using TOracleQuery with variables or a TOracleObject instance would be fine. Meanwhile I learned the following: "REF cannot operate on column objects or otherwise nested objects, because such objects do not...

I found some examples, but as I said they all refer to typed tables. If I look at TOracleObject.Create I have to give a tablename as third parameter to make the object persistent. But I don't have a table, I only have a _column_. Let's say I have a table with three columns: ID number...

Delphi 7, DOA 4.0.3 trial version with Oracle 9.2 Just wanted to know if there is an example in your documentation. (Not using typed tables...) If not, I would be pleased if you could post a few lines to show me how do do it.

We're trying to update a table, that contains a column 'SHAPE' of type 'SDO_GEOMETRY', but that far with no success. Could you please point me to an example of how to update an object column? All examples I found refer to typed tables and not a single object column.