Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help! CREATE DIRECTORY on NT !!BFILE!!
A copy of this was sent to bonanos_at_yahoo.com
(if that email address didn't require changing)
On Tue, 22 Sep 1998 13:36:51 GMT, you wrote:
>Hi I am trying to create a directory on winnt called gif_dir
>
>I use:
>
> create directory gif_dir as 'c:\gif'
>
>then:
>
>update the_lob set f_lob = Bfilename('gif_dir','sa.gif') where id ='20'
>
>
>then in PL/SQL when I try and select f_lob into a bfile variable called
>image1, I get error ORA-22285
>
>The directory doesn't exist??
>
since the directory was created as
create directory gif_dir ...
it is created in UPPERCASE. When you call bfilename, you are giving it a lower case name. Either
>Please help!
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Tue Sep 22 1998 - 10:38:55 CDT