Piping data out of PL/SQL ?

I'm trying to use the processing features of pl/sql code blocks, but I want to output the results either to stdout or (more desirably) to a Unix pipe. The examples in the manuals seem to show only DML statements - the results of the if/else or while constructs are used in update, insert or delete statements.

I'd rather not create temporary tables to hold output, especially when the end goal is to get data in either unix files, or piped to formatting scripts and then out to the printer......

Perhaps I'm missing something as I make the transition from another RDBMS to Oracle.... I would sure like some ideas.

		Rich Pinder
		USC School of Medicine
		(213) 342-1640

		rpinder_at_usc.edu

    ||||||||||||||||||||||||||||||||||||||||||||||||||

-- 


Rich