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 ==================================
