DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How can I open an OS text file inside one Stored Procedure

  1. 07-10-2002, 01:27 PM #1
    dpraharaj
    dpraharaj is offline Junior Member
    Join Date
    Jul 2002
    Posts
    6
    HI,

    I have one Operating System text file in particular directory in UNIX environment . How can I open this file inside one PL SQL or Stored Procedure.

    Thanks in advance.


    Dillip

  2. 07-10-2002, 01:33 PM #2
    sreddy's Avatar
    sreddy
    sreddy is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    You have to use utl_file_dir and have OS file in that directory and open thru PL/SQL. Check it out Oracle Docs OR this forum threads 'utl_file_dir' as search string.
    Reddy,Sam
  3. 07-10-2002, 02:50 PM #3
    dpraharaj
    dpraharaj is offline Junior Member
    Join Date
    Jul 2002
    Posts
    6
    Thanks Sam
  4. 07-10-2002, 03:00 PM #4
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    plz dont duplicate your posts, post once if we know the answer we will help you
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width