Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Detecting "SHOW" options

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US