The procedure just calls a pl/sql wrapper procedure to
get the hostname.

CREATE OR REPLACE PROCEDURE proc1 IS
dt varchar2(100);
BEGIN
shell('hostname');
END;
/



--- puru pradhan <[Email Address Removed] wrote:
> what you are using for Displaying the output?
> DBMS_OUTPUT etc??
>
> rgds
> ============
>
> --- Anandhi Narayanswamy <[Email Address Removed] wrote:
> > I am executing a stored procedure from a sqlplus
> > session on a client. Any output is displayed on
> the
> > server. How do I get it to display at the client?
> >
> > Thanks in advance
> > Anandhi
> >
> > __________________________________
> > Do you Yahoo!?
> > The New Yahoo! Search - Faster. Easier. Bingo.
> > http://search.yahoo.com
> >
> > --------
> > Oracle documentation is here:
> >
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > To unsubscribe: send a blank email to
> > oracledba-[Email Address Removed] > To subscribe: send a blank email to
> > oracledba-[Email Address Removed] > Visit the list archive:
> > http://www.LAZYDBA.com/odbareadmail.pl
> > Tell yer mates about http://www.farAwayJobs.com
> > By using this list you agree to these
> > terms:http://www.lazydba.com/legal.html
> >
>
>
________________________________________________________________________
> Missed your favourite TV serial last night? Try the
> new, Yahoo! TV.
> visit http://in.tv.yahoo.com


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
Oracle LazyDBA home page