By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,740 Members | 844 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,740 IT Pros & Developers. It's quick & easy.

Printing a File From PL/SQL In Oracle 9i

P: n/a
Iam using Oracle 9i database. Iam generating reports through Database
Trigger into separater files. I want to print these files on frequent
intervals from Stored Procedure. Is it possible in Oracle 9i and how
do we proceed to do this?
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
su***************@yahoo.com (Sudheer Kumar Mandava) wrote in message news:<63**************************@posting.google. com>...
Iam using Oracle 9i database. Iam generating reports through Database
Trigger into separater files. I want to print these files on frequent
intervals from Stored Procedure. Is it possible in Oracle 9i and how
do we proceed to do this?


I believe the package you want is DBMS_FILE.
Jul 19 '05 #2

P: n/a
Sudheer Kumar Mandava wrote:
Iam using Oracle 9i database. Iam generating reports through Database
Trigger into separater files. I want to print these files on frequent
intervals from Stored Procedure. Is it possible in Oracle 9i and how
do we proceed to do this?


There is a wonderful document called "Oracle9i Supplied PL/SQL Packages and
Types Reference" in the Oracle documentation set. I suggest anyone writing
PL/SQL wants to have a printed copy of the table of contents.

Check out DBMS_OUTPUT and UTL_FILE.

/Hans
Jul 19 '05 #3

P: n/a
Hans Forbrich <fo******@yahoo.net> wrote in message news:<Htgdc.15255$Sh4.13386@edtnps84>...
Sudheer Kumar Mandava wrote:
Iam using Oracle 9i database. Iam generating reports through Database
Trigger into separater files. I want to print these files on frequent
intervals from Stored Procedure. Is it possible in Oracle 9i and how
do we proceed to do this?


There is a wonderful document called "Oracle9i Supplied PL/SQL Packages and
Types Reference" in the Oracle documentation set. I suggest anyone writing
PL/SQL wants to have a printed copy of the table of contents.

Check out DBMS_OUTPUT and UTL_FILE.

/Hans


He is already using UTL_FILE to write the reports to a file. His
question was how to print them.

Sudheer-
You will have to use external procedures or Java to do that. check out
metalink on that.

HTH
-dharma
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.