yet another LONG column restriction

As you may be aware you cannot retrieve a long column from a 'remote' database. You can however retrieve other columns in the same table.

That is, if you use SqlPlus, but if you use PL/SQL (at least from within SqlPlus, haven't tried Forms yet) you *cannot* retrieve *any* columns. You get a hint of this if you try to 'describe' this table, as you get an error about long columns in the table. Presumabley PL/SQL gets a similar problem when trying to validate/parse your code and falls over (with something like cannot access the table).

One way round this is to create a view of the table excluding the long column.

Oracle says its a bug to be fixed in an as yet unannounced release of PL/SQL.
(ps: this was Oracle V6, PL/SQL 1.0.35; I think they said it would be fixed in 1.0.46?)

--
Steve Corbett.                    vvv
                                 [. .]   "just one person's opinion"
p0070623_at_brookes.ac.uk -------o00-(_)-00o---------