Re: pl/sql and host help PLEASE!

you can't do so directly in 7.2.

your options are:

1. pipe the request using dbms_pipe to a pro*c (or sqr or oraperl or anything else with access to both oracle and the os) listener, which will do it for you. there is a free implementation called plex on the oracle government site somewhere. you can use a private pipe to return results to the calling procedure.
2. use utl_file to write a file, and have a shell trigger script pick up on that and execute the desired call -- Andrew - Wizzard

barnetaj_at_bp.com

Patrick Finnicum <pfinn_at_creighton.edu> wrote in article <Pine.HPP.3.95.980325172006.11268A-100000_at_bluejay.creighton.edu>...
>
> Sorry about the repost to everyone, but I'm afraid my last post may have
> been smothered.
>
> I'm attempting to call a unix script from within a pl/sql script using
 Ora
> 7.2 on an HPUX box. I've dug thru the packages to no avail and am kinda
> forced into pl/sql rather than forms. Anyone help with some source???
>
> Any help is greatly appreciated as I feel stuck in a deep dark hole.
>
> -p
>
>
>
Received on Wed Mar 25 1998 - 00:00:00 CST