utl_file open error

Posted on 16th Feb 2014 07:03 pm by admin

i have file in the unix path

Path /popdev01/pop/popdevb/tfi/

File name: qua01

this path is hard coded in the table PQ10. i will be taking this value and get assinged to the variable "Var_val"

DECLARE
Fic_Lu UTL_FILE.file_type ;
Var_val VARCHAR2(50);
vs_mod_r := 'r' ;
SELECT val
* INTO Var_val*
* FROM pq10*
* WHERE pq10_COD_PRM='RF';*
Fic_Lu := UTL_FILE.FOPEN ( Var_val,'qua01', vs_mod_r, 3000 ) ;
exception
WHEN UTL_FILE.INVALID_PATH THEN
dbms_output.put_line(' Invalid path');
end;
while i run i get invalid path error

Give me ur suggestion

Your Answer:

Login to answer

Other forums

Display error above the login forum help!
Hi guys. just so you know im not asking for someone to do this for me I just need to be pointed in t

Undefined index: username HELP NEWBIE
I am trying a simple login/logout for my website. It works well with checking if the username exists

Simultaneous select/update/insert
Hi

How would I need to go about when 2 users update a single row simultaneous? And how would

private constructor
Hello,

Can we create a constructor as private? If yes, what is the use of it? If no, why can'

PHP login form help (Done Most of It)
Hi i am having a problem, when i try logging in it is always saying "Invalid Login" im not

noob question
i traying to do a php form with auto replay for both(me and the user who send me a mail),

a u

Syntax Help
I'm trying to make a form that edits a php file which contains config settings. I'm using strings t

TinyMCE / Ajax Postback Problem
Hiya all,

I have a page which loads the TinyMCE editor. On the postback I obviously want to f

Module pool selction screen parameters combination logic
Hi floks,
Am new to the module pool development ,Recently i have created one program based on

Secure FTP
Hi experts,
There is no SFTP action in MII workbench.
This means it needs developing custo