Computing.Net > Forums > Database > SQL *Plus Help

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

SQL *Plus Help

Reply to Message Icon

Name: henry_joshua
Date: May 29, 2006 at 03:59:42 Pacific
OS: Win XP
CPU/Ram: p-iv,256
Product: zenith
Comment:

Dear Friends,
I am learning PL SQL for the first time. In one program I have given the dbms_output.put_line statement. While executing the program it shows that the "PL/SQL procedure Executed Successfully", but there is no output. How do I display the output on the screen? I am using Personal Oracle 8.

Pls help

Thanx in advance


Henry Joshua



Sponsored Link
Ads by Google

Response Number 1
Name: lchi2000g
Date: June 1, 2006 at 10:58:36 Pacific
Reply:

SQL> set serveroutput on
SQL> execute <your_PL/SQL>


Luke Chi


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: SQL *Plus Help

SQL Query Help www.computing.net/answers/dbase/sql-query-help/653.html

SQL command displayed on report www.computing.net/answers/dbase/sql-command-displayed-on-report/423.html

connection problem in oracle9i? www.computing.net/answers/dbase/connection-problem-in-oracle9i/540.html