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/

Did you know?Explore Trending and Topic pages for more stories like this.
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
No comments posted yet

Your Answer:

Login to answer
121 Like 39 Dislike
Previous forums Next forums
Other forums

Giving the below syntax error
Dear Experts,

I have used 2 buttons in gui status as display and cjhange.When the user wi

A little help in c#
i am doing a simple paint program using c# i want to draw with the mouse so i wrote the code of the

How to generate a random array of integers subject to a certain constraint
I am writing a program that asks the user to enter an integer N and then generates a random array of

mod_rewrite.c on windows ??
why it's not working on windows while it's working on other hosts???

this is the code i got

Send current URL in URL with a $_GET variable problem.
Hello community,

I have created a function that gets the current variable of a page, example:

Dynamically allocating the number of rows in a table based on a variable value
Hi,
I have situation here which i cannot resolve, I have a variable temp which stores the num

Pls help with PHP
Pls can anyone direct me on how to create a user account for a customer. For example i want know if

Undefined Index Notice In Internet Explorer Only
I am getting the following notice:

QuoteNotice: Undefined index: jrox in /home/ycsn/public_h

Socket Server Response Headers
Earlier I had a post about my Socket Server, I wasn't able to get it to connect, now I can

I

How can i steam a video on my PHP site? (non YouTube)
Basically I have a PHP site and don't want to give page rank to YouTube. I just want to stream a bas

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash