Re: Procedure Builder & Built-In Packages

Sebastian Frey wrote:

>
> Many thanks in advance,
>
> -Sebastian Frey

The TEXT_IO Package is a Package only supproted in the Tools-Environment (for example in Forms)

If you want to display messages in your Program running on the Server you have to use DBMS_OUTPUT.put_line instead of TEXT_IO.putline Don't forget to specify SET SERVEROUTPUT ON.

exaxmple:

Your procedure: create or replace repcedure test as

		begin
			dbms_output.put_line ('hallo');
		end;

Test on the server:

>sqlplus
>set serverout on;
>execute test;
Received on Fri Sep 11 1998 - 10:39:48 CEST