Re: o/s system calls - can it be done?

Hi,

    I am not sure but I think PL/SQL does not support the host command. Even if it does, The host command will shell to the client OS and not the Server OS. Hence you cannot run a script on the server by calling the PL/SQL block from the client. Correct me if I am wrong.

Best Regards

Naresh

Me wrote in message <35CF3B20.97E034AD_at_hotmail.com>...
>from the SQLPLUS prompt:
>
>SQL> ! ls -l
>
>I believe you can also use ' host ls -l ' or just type host to spawn a
>shell and exit from the shell to return to sqlplus.
>
>
>
>johnvue_at_gte.net wrote:
>
>> Is there any way to do system (shell) operations within PL/SQL?
>>
>> Let's say I had a PL/SQL block and I wanted to do a "ls -l" to get a
>> directory listing. Is there any way to do that?
>>
>> In C Language, I can do
>> {
>> x = system("ls -l");
>> }
>>
>> Thanks.
>
>
>
Received on Wed Aug 12 1998 - 03:05:00 CEST