Detecting "SHOW" options

From: Henry Hayden <gumzilla_at_voicenet.com>
Date: Sat, 17 Nov 2001 22:11:59 GMT
Message-ID: <3BF6E132.A56FA741@voicenet.com>

Is it possible to programmatically detect the SQL*Plus environment settings- such as SET SERVEROUTPUT, etc.? I'd like to be able to find out what certain settings are so that I can store them, change them as needed within a script, and then change them back to their original settings. (I'm using SQL*Plus 8.1.5)

So, I not only need to detect the settings, but I also need to know how to set them from within PL/SQL.
This may be picky, I know, but I'd like to know, in any case.

Thanks!

Henry Received on Sat Nov 17 2001 - 16:11:59 CST