Oracle-7.1 : dbms_output.put_line() is not working in Pl/SQL

From: <hemlataassudani_at_my-deja.com>
Date: Thu, 28 Oct 1999 13:22:45 GMT
Message-ID: <7v9in1$pra$1@nnrp1.deja.com>

I have created a program to accept a name from the user and to display it back using " dbms_output.put_line(mname); "

it displays an error :
the identifier dbms_output.put_line must be declared. Why this error occurs ? Even if I have executed all the catalog files etc. : they are as follows :
catalog.sql
caproc.sql
p7pup.sql

If there any other file is required to be loaded , give the list and if possible with full path also.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 28 1999 - 08:22:45 CDT