Re: How to call shell script from PL/SQL ?.

Make sure you have write access to the dump directory. This should be set in the UTL_FILE_DEST parameter I think. I know this is the case when you use the UTIL_FILE package to write data to the OS. Not sure if this applies to your case.

Raj wrote:
>
> Tom,
> External procedure fn getting executed correctly but the action is not being
> done . i,e creating a file / deleting a file / executing a file . Could you
> please let me know what i'm missing in my process.
>
> Here is the fn:
>
> int call_system ( char *progname , int a )
> {
>
> FILE *fp;
>
> fp = fopen ("test.txt","w");
>
> fprintf( fp , " First line is ! ");
>
> fclose( fp );
>
> }
>
> This code doesn't create the file "test.txt" .
>
> Tom Zamani wrote:
>
> > You need to provide us what version of database you are using.
> > If 7 then I have no Idea I am not sure if you can do that.
> > if 8.X you need to use external procedures in oracle
> > if 8.1.6 there is a package in oracle which could help you with this (I
> > don't know the name of the package).
> > I have used external procedures to do ftp ,cp, mv send email etc, and it is
> > very fast.
> >
> > Tom
> >
> > Raj <rajarulmani_at_att.com> wrote in message news:38FDF480.9D00B0B1_at_att.com...
> > > Hi,
> > > can any one tell me how to call a shell script from PL/SQL ?.
> > >
> > > Thanks,
> > > Raj
> > >
> > >
 

-- 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
        _   __         __        __
       | | / /__ ___  / /_____ _/ /_   Email :
       | |/ / -_) _ \/  '_/ _ `/ __/    venkat1_at_one.net
       |___/\__/_//_/_/\_\\_,_/\__/     venkat_rajagopal_at_yahoo.com

                  < http://w3.one.net/~venkat1 >

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++