Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

how to get dbms output from sql plus

59 views
Skip to first unread message

TorontoTrader

unread,
Jan 4, 2007, 10:38:45 AM1/4/07
to
Hello
If i use sqlplus to run pl/sql procs. how can i get dbms output
contents printed in my sqlplus window.
I use windows workstatrion to connect to oracle in a unix server. can i
spool the dbms output file to my windows workstation

DA Morgan

unread,
Jan 4, 2007, 11:23:29 AM1/4/07
to

http://www.psoug.org
click on Morgan's Library
click on DBMS_OUTPUT.
Run the demos.
--
Daniel A. Morgan
University of Washington
damo...@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

mohd....@gmail.com

unread,
Jan 21, 2007, 12:16:25 AM1/21/07
to
to show the output on sqlplus just run this command :
SQL > set serveroutput on

or use spool command to get output into a file.

Regards;


TorontoTrader أرسلت:

0 new messages