Oracle PLSQL: Write to output file
Posted on 2004-03-22
I'm new to PLSQL and I been testing some of its features. I need to select columns from a table and write them to an output file. How can I do this? For example, let say that I have an "EMP" table that has "NAME", and "Address" columns. How can I select both of these columns and write it to a file using PL-SQL?
(I've been trying to use a package called "logfilepkg.writelogline" which always seems to give me 21/13 PLS-00201: identifier 'LOGFILEPKG.WRITELOGLINE' must be declared
21/13 PL/SQL: Statement ignored.)
Can anyone provide me with a simple example just to get me started? Thank you very much for your time.