How to execute a message in PL/SQL from SQL command prompt

5 pts.
Tags:
Database
PL/SQL
SQL
Sir,
I have written a small message using PL/SQL. When I execute that query in SQL CMD prompt, I'm unable to see my output. How can I execute my output in SQL?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Are you displaying your message using DBMS_OUTPUT?

If so, you probably only need to run this command:

SET SERVEROUTPUT ON;

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    What output you want to see, that is not cleared here, however, if setup was going smoothly, you can try this, sqlplus "/as sqlsba", though more info is required.
    141,290 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: