Reading flat files from pl/sql

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Pedro Hernandez

    Reading flat files from pl/sql

    This might seem strange, but I would like to know if it is possible to
    open a text file (for reading) from pl/sql.

    Ora8i on RHL7.3


    Thanks,
    ph
  • mcstock

    #2
    Re: Reading flat files from pl/sql

    from a stored PL/SQL procedure? yes, as long as it's on the database
    erver -- look into the UTL_FILE package

    or are you referring to reading a file from the client machine? if so,
    what's your development tool?

    note that in 9i you could also look into external tables (MetaLink note
    Note:150740.1)

    -- mcs

    "Pedro Hernandez" <phph109@yahoo. eswrote in message
    news:9d013a92.0 311131124.8474b ef@posting.goog le.com...
    This might seem strange, but I would like to know if it is possible to
    open a text file (for reading) from pl/sql.
    >
    Ora8i on RHL7.3
    >
    >
    Thanks,
    ph

    Comment

    • Pedro Hernandez

      #3
      Re: Reading flat files from pl/sql

      "mcstock" <mcstockspamplu g@spamdamenquer y.comwrote in message news:<ALGdnSjOe f7YQy6i4p2dnA@c omcast.com>...
      from a stored PL/SQL procedure? yes, as long as it's on the database
      erver -- look into the UTL_FILE package
      Thats it, thanks a lot!
      ph

      Comment

      Working...