On Mon, April 27, 2009 02:44, Daiesh wrote:
>
> Hi,
>
> UTL_FILE.FOPEN( DIRECTORY_NAME, FILE_NAME, 'R' );
>
> the above method is used to open file and it throws the exception when
> opening the file if file is not exist.
>
> Thanks
> Daiesh
>
> On Apr 23, 6:21 pm, "Rob Wolfe" <rob.wo...@oraclegeeks.com> wrote:
>> On Thu, April 23, 2009 08:36, Oracle Deen wrote:
>>
>> > Hi,
>>
>> > My requirement is to prepare Reports 6i/10g report display all
>> countries
>> > and
>> > its flag. I have a table as follows
>>
>> > TableName: country
>>
>> > Country code Country name flag path
>> > US United States c:\flag\us.jpg
>> > IN INDIA c:\flag\in.jpg
>>
>> > In the above example, i have placed all flag images specified path.
>> What i
>> > want is how to check the image is really present in the specified
>> path. So
>> > there should be a function will return Yes if file exist else no.
>>
>> > Thanks in Advance
>>
>> > Deen.
>>
>> I would think that you might be able to use textio.fopen('foo.txt','R')
>> and then check to see if you have a valid file handle but that is all
>> that
>> I can think of off the top of my head.
>>
>> Someone else might have better wisdom
>>
>> Rob
> >
>
A perfect solution, catch the exception and you are off to the races.
Thanks for coming back with the solution that worked for you!
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
