SQL *Plus Help

Original Message

Name: henry_joshua
Date: May 29, 2006 at 03:59:42 Pacific
Subject: SQL *Plus Help
OS: Win XP
CPU/Ram: p-iv,256
Model/Manufacturer: 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

Report Offensive Message For Removal

Response Number 1

Name: lchi2000g
Date: June 1, 2006 at 10:58:36 Pacific
Subject: SQL *Plus Help

Reply: (edit)

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

Luke Chi

Report Offensive Follow Up For Removal


Oracle spool output to file visual foxpro database sync Oracle errors SQL query help SQL Select statement help	cant access ms sql server SQL compact multiple row update date format in SQL Server Saving SQL Database sql server update

Access - Form Control for...

using Photo Editor to dis...

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: SQL *Plus Help

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL: