Re: Oracle WebServer (PL/SQL & Unix)
Date: 1996/11/20
Message-ID: <3292933d.817054_at_dcsun4>#1/1
If the file is text, and you have 7.3, you can implement the cp in pl/sql using UTL_FILE. Otherwise, you can use dbms_pipes to do what you want. for a good starting place on doing this, check out http://govt.us.oracle.com, follow the link to tech center/downloadable utilities. There you will find PLEX (PL/sql EXtender) that allows you to easily implement a pl/sql subroutine in C....
On 18 Nov 1996 19:33:35 GMT, Egli Shelley M <egli_at_space.honeywell.com> wrote:
>Does anyone know whether you can execute a UNIX shell script inside a PL/SQL
>package procedure? What I'm trying to do is create a document check-in form.
>The form basically contains 3 fields: 1) name of the document, 2) source
>directory (where doc currently resides), & 3) destination directory (where doc
>is to be placed). Once the user fills out the form on the Web, they click on the
>'Check-in' button. It would then run my Unix shell script which is basically
>just a 'cp' command. Here's part of my procedure. Currently I show another
>procedure to be executed (checkinAction) when the button is clicked...this is
>where I'm stumped. How do I call a Unix script inside this Oracle procedure?
>Appreciate any suggestions.
>
> htp.formOpen ('pdm.checkinAction');
> htp.formText ('doc_nbr');
> htp.formText ('src_dir');
> htp.formText ('des_dir');
> htp.formSubmit (null,'Check-in');
>
>
Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com
- Check out Oracle Governments web site! -----
Follow the link to "Tech Center"
and then downloadable Utilities for some free software...
statements and opinions are mine and do not necessarily reflect the opinions of Oracle Corporation Received on Wed Nov 20 1996 - 00:00:00 CET