Re: System command from a stored procedure?

Hi,

The only way that you can do this is by using the DBMS_PIPE package. There is a source code listing for a PL/SQL package and Pro*C daemon program in Chapter 8 of the Application Developer's Guide (at least in verion 7.3) which will do what you want. If you can't find it or need help let me know as I have set up something similar.

Mark Aurit wrote:
>
> In ORACLE*Forms I can execute an operating system
> command (in this case a simple UNIX "cd") with
> something like:
> HOST('cd /usr/local/bin');
>
> Is it possible to create an operating system command
> from within a stored procedure? None of the books
> I have makes mention of it, and when I tried a
> simple stored procedure it wouldnt compile.
>
> Thanks, Mark
> mark_aurit_at_mail.northgrum.com
 

-- 
________________________________________________________________________
Rodney Schuler Database Administrator | Department of Computing Services
Internet: Rodney.Schuler_at_USask.CA     | University of Saskatchewan
Voice:    (306) 966-4862              | 116 Science Place
FAX:      (306) 966-4938              | Saskatoon SK  S7N 5E2  (Canada)