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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yosi Greenfield
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
