Utl_file.fopen
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Utl_file.fopen

  1. #1
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758

    Utl_file.fopen

    Code:
    EXECUTE UTL_FILE.FOPEN('E:\DATA','ITEM.DAT','R');
    I am getting the error PLS-00306 wrong number or types of argument.
    UTL_FILE_DIR is set, the path and file name is aslo correct.
    Any clue?

    TIA
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  2. #2
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi, you have to satisfy fhe return-type of fopen;
    This is the handle which identifiy the file for other operations.

    Orca

    Code:
    UTL_FILE.FOPEN (
    location IN VARCHAR2,
    filename IN VARCHAR2,
    open_mode IN VARCHAR2)
    RETURN UTL_FILE.FILE_TYPE;

Posting Permissions

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



Click Here to Expand Forum to Full Width