Q
Problem solve Get help with specific problems with your technologies, process and projects.

dbms_output.put_line command is not working

I have installed Oracle 8i Enterprise Editions as an Oracle server (8.1.1.6), but the dbms_output.put_line command is not working. I have done the command in the following statements:

SQL> 1  declare 
SQL> 2  dbms_output.put_line("Babu") 
SQL> 3* end; 
SQL> declare 
  2  dbms_output.put_line("Babu"); 
  3  end; 
  4  / 

dbms_output.put_line("Babu"); 
           * 
ERROR at line 2: 
ORA-06550: line 2, column 12: 
PLS-00103: Encountered the symbol "." when expecting one of the following: 
constant exception <an identifier> 
<a double-quoted delimited-identifier> table LONG_ double ref char 
time 
timestamp interval date binary national character nchar The symbol 
"<an identifier>" was substituted for "." to continue. 
ORA-06550: line 3, column 1: 
PLS-00103: Encountered the symbol "END" when expecting one of the following: 
begin function package pragma procedure subtype type use <an identifier> 
<a double-quoted delimited-identifier> cursor form current 

Could you please provide a solution?


Instead of DECLARE, use BEGIN. You have an END, but not a beginning. And do not put a semicolon after the BEGIN keyword.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close