Re: HOST command in plsql ... exists ?

From: giorgio.sorbara _at_ sorcius.com <_at_>
Date: Wed, 27 Jun 2001 21:14:27 +0200
Message-ID: <9hdbb2$h5g$1@news.mclink.it>

hi there,
you can use an external C procedure... and call it within a PL/SQL block. I did it a couple of time... not an export though. It's not clear however whether you have to export data in exp format or not. If you do not have such a constraint (and no LOB objects) i'd rather use utl_file package and write everything on a plain text file.

HTH
G

"Walter Pircali" <walter_at_entity-ag.it> wrote in message news:3B39E686.5060807_at_entity-ag.it...
>
> Hi to all,
>
> does anybody knows if there's an 'HOST' command in plsql (stored
> procedure ?). I have an aix server with an 8.1.5 and have to make a dump
> (with exp) at runtime. Is there a way (maybe an oracle package -- but
> I didn't find any) to launch an host command from a stored procedure ?
>
> thanks in advice for every tip ...
>
> bye
>
Received on Wed Jun 27 2001 - 14:14:27 CDT