Re: Oracle Security help please?

From: <mark.powell_at_eds.com>
Date: Tue, 02 Mar 1999 13:35:32 GMT
Message-ID: <7bgpf4$nga$1@nnrp1.dejanews.com>

In article <19990301192444.20412.00001772_at_ng-fz1.aol.com>, vtuttl_at_aol.com (Vtuttl) wrote:
> Are there any 'known' keystrokes for shelling out of an Oracle database which
> runs on a Unix box other than the usual Unix keystrokes to end a shell script?
> ie... ^c
> ^u
> ^s
>
> etc...?
> thanks!
> hidden_at_users.request
>

This may not be what you are looking for but:

From SQL*Plus you can issue Unix commands using the host command which is usually set to '!' (See set command parameters), i.e., !ls -ltr.

From a pl/sql script, procedure, function, or package you can us the dbms_pipe package to pass messages to a program which could be OS level commands or script names that the pipe reader issues.

Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice --

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 02 1999 - 07:35:32 CST