Re: sqlplus command

Milind,

You can't do sqlplus from procedures. There are some ways to get output from pl/sql. One is to use the dbms_output package, which does send output to a sqlplus session if you have set serveroutput on.

Another idea that's used might be to put your output lines into a staging table, each record containing a field with the sequence number of that line in the output. Then when the procedure finishes populating that table, simply select the data from the staging table. (Oracle 8i global temporary tables are good for that too.)

Good luck,

y

milind ambegaoker wrote:

> Dear mailing list,
> is it possible to execute SQLPLUS commands from
> subprograms like procedures and functions ?
> If possible pl. send me how to do it ?
> If not please tell me why and alternate way
> as i want to write sub programs(procedures) that would
> generate reports on the SQL prompt by using the
> SQLPLUS formatting commands.
>
> ____________________________________________________________
> Do You Yahoo!?
> For regular News updates go to http://in.news.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?milind=20ambegaoker?=
> INET: milindora_at_yahoo.co.in
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--
Thanks,

Yosi


---------------------------------------------------------
Yosi Greenfield
Oracle Certified DBA
ygreenfield_at_compuserve.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yosi Greenfield
  INET: yosi_at_comhill.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).