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

very easy question about SQL info
Hello,
I think that I have a very easy question.
I know how to create a form using php SQL and

Multidimensional Array into an Html table, help!
Hello all, I am new to HTML/PHP so any help would be great.

I have a multidimensional array f

error help - Dynamic Image
I've been working on making my site less cluttered in the directories and more secure lately. In an

Check something, wait, check again, do something!
Hi guys.

I wonder if someone can help me with this.

Basically, what I want to do is (

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

$action = "insert"; //$action = $_GET['action'];
$action = "insert";
//$action = $_GET['action'];

why is this invalid type? I am

Is there a more efficient way to code this than what I have?
I have three associative arrays.

$combinedSettings
$userSettings
$defaultSettings

Inserting multiple records from single form
I've found a number of threads that deal with this issue, but I'm new to php and coding language so

remove innitial

and

tags
i am using tiny_mce as a text editor for my CMS.
buy now the problem is it add <p>

How to generate a text file using php...?
Hi,
Can anyone give me code to generate a text file using php


Thanks in advance

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