ktadimeti wrote:

> I wish to output text from a stored procedure. How do I do this?

There are different way, depending what you really need:

1. You can create a selectable stored procedure:

create procedure p1 returns (output_text varchar(3000)) as begin
for select something into :output_text do suspend;
end

If you wish to get this into a text file, you can use ISQL or a tool
like FBExport. FBExport could be used like this:

fbexport -SC -Q "select * from p1" -f- -d/path/to/database.fdb

The result is a quoted string, but you can use a tool like sed to remove
quotes.

2. You can create an external table (which almost like a regular textual
file if you use CHAR data type) and INSERT into it.

3. If you only want to post "events" from the database, it's better to
use the Events functionality.

Maybe you can tell us why you need this feature, and we can tell you
what is the best solution for that.

Regards,


--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================