Printing a File From PL/SQL In Oracle 9i

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Sudheer Kumar Mandava
    #1

    Printing a File From PL/SQL In Oracle 9i

    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?
    Tags: None
    • Ed prochak
      #2
      Re: Printing a File From PL/SQL In Oracle 9i

      sudheerkumar_20 00@yahoo.com (Sudheer Kumar Mandava) wrote in message news:<634c6f68. 0404080324.444c 08cb@posting.go ogle.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.

        Comment

        • Hans Forbrich
          #3
          Re: Printing a File From PL/SQL In Oracle 9i

          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

            Comment

            • dharma-
              #4
              Re: Printing a File From PL/SQL In Oracle 9i

              Hans Forbrich <forbrich@yahoo .netwrote in message news:<Htgdc.152 55$Sh4.13386@ed tnps84>...
              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

                Comment

                Previous template Next
                Working...