Okay, not strictly speaking anything to do with Reports or Disco, however since I always favour a 'low tech' approach to my reporting requirements this little snippet is a gem...

html from sql*plus

cool little thing!

Used this to implement an error report straightway.

I can't get it to work, it don't recognise the 'markup' word. I'm on sql 9.2 though.

yep, same error encountered by friendly neighbour techie just now.

Its to do with the sql*Plus version . If you have anything earlier than SQL*Plus: Release 8.1.7.0.0 - Production
you will get a "Invalid Set option" message

we realised that it is not related to the database version which is Oracle9i Enterprise Edition Release 9.2.0.4.0.

cheers
Vin

Yes indeedy.
I've got one of our DBA's to raise this as a Tar.
It seems the toolset that you can use through concurrent manager scripts is tied to the apps tier.
So, even though we have 9.2.+++ the apps tier by default runs 8.0.2 versions of plus, sql*ldr etc.
Which (to me anyway) is pants.

You can force the oracle home to use the r9 toolset providing you have access to the unix shell, but this is only valid for the shell session. It cannot be done via conc programs.

I'll let you know how we get on with our TAR.

Cheers

For the interested...
TAR 4913606.993 refers.