OraFAQ Forum: Server Administration » How to set Image path for the column ?

Home » RDBMS Server » Server Administration » How to set Image path for the column ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to set Image path for the column ? [message #373068]

Mon, 26 March 2001 06:14

aditya
Messages: 36
Registered: March 2001

Member

Hi,
Well inorder to store an image say v will declare a column with "BFile" datatype in table(say T1) .But how to set the path for the column to pick up the image located in particular directory(c:\Windows\x.bmp)?.How to do this at the SQL prompt?Where do and how do we specify this path?

Thanks
Aditya

Report message to a moderator

Re: How to set Image path for the column ? [message #373069 is a reply to message #373068]

Mon, 26 March 2001 07:11

Prem
Messages: 79
Registered: August 1998

Member

Aditya,

you need to first create a directory (in oracle) which points to the os directory where the image files are stored. Use the CREATE DIRECTORY IMG_DIR ... syntax. You will have to use this directory name (IMG_DIR in this case) in the BFILENAME() function. In your plsql, you can say
TBFILE BFILE := BFILENAME('IMG_DIR', 'HELLO.BMP');

hth

Prem :)

Report message to a moderator

Previous Topic:	SQL Editing / Executing
Next Topic:	Spooling generates more records...why

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 02 09:26:42 CDT 2024