Re: To run the host command from PL-SQL

In article <7du12q$941$1_at_brokaw.wa.com>,   "Deepa Raman" <DeepaR_at_aeimusic.com> wrote:
> Hi all,
> IF I want to run the host command from within a PL-SQL,
> for ex,
>
> declare
> dummy varchar2(10);
> begin
> dummy := '*.fmb';
> /* host *.fmb */ How do write this command*/
> (i can do it from SQL Prompt not from a PL-SQL procedure.,)
> end;
>
> Deepa.
> deepar_at_aeimusic.com
>
>

What you mean by excecuting this '*.fmb' string? Host is for excecuting programs outside oracle. It's like :

host('notepad.exe'); or host(program_path || 'pkunzip.exe ' || my_zip_file || ' ' || directory_to_unzip)

Hope it helps.

LK

[Quoted] -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 01 1999 - 08:21:42 CEST