plsql file find problem!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: plsql file find problem!

Hybrid View

  1. #1
    Join Date
    Jun 2001
    Posts
    316
    Hi,
    This is a real vague problem..i dunno if it is a problem in the code.

    file_id1 := utl_file.fopen('/usr/local/data','file1.ges','r');

    Now I ve placed the file xactly in here.....But this file is never found


    ORA-06510: PL/SQL: unhandled user-defined exception
    ORA-06512: at "SYS.UTL_FILE", line 101
    ORA-06512: at "SYS.UTL_FILE", line 157
    ORA-06512: at "INSERT_INTO_TABLE", line 19
    ORA-06512: at line 1

    this is the error!!
    can Any1 point out what it mite be?
    Thax in advance

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    What is your UTL_FILE_DIR init.ora setting?
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Jun 2001
    Posts
    316

    file find

    No..actually it finds some file.....
    But somefiles it doesn't...thats what amazes me!!


  4. #4
    Join Date
    Jul 2000
    Posts
    243
    Hi

    utl_file_dir identifies the directories that are permitted for us be a pl/sql procedur. each directory must be specified with a separate tl_file_dir paramater in the init.ora file. i think you have a problem there.

    also, have you set any exceptions in your procedur? you can us a set of utl_file exceptions.

  5. #5
    Join Date
    Jun 2001
    Posts
    316

    file find

    UTL_FILE.INVALID_OPERATION
    it throws this exception

  6. #6
    Join Date
    Jul 2000
    Posts
    243
    Hi

    can user oracle write to '/usr/local/data','file1.ges'

  7. #7
    Join Date
    Jun 2001
    Posts
    316

    thank you

    Thanx buddy....
    It worked....
    so foolish of me...
    thanx again

  8. #8
    Join Date
    Jul 2000
    Posts
    243
    Hi

    :-)

    (for some unknown resone i can not copy smilys...)

  9. #9
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by shawish_sababa
    Hi

    :-)

    (for some unknown resone i can not copy smilys...)
    Try to "write" your smilie without the nose (live the minus sign out). Or check the follwing link for all standard available smilies in this forums:
    http://www.dbasupport.com/forums/ind...on=showsmilies
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  10. #10
    Join Date
    Jul 2000
    Posts
    243
    thank's

    shawish_sababa

    shawish_sababa@hotmail.com

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