Loading images into Oracle

[vamsioracle]

Hi All

I want to load images into Oracle 9i database.

My package should automatically load from a predefined folder on my sytem and load into database. Is there any possibility to set the physical location path on local system and to load into the database.

Thanks in advance
vamsi

[madankarmukta]

Hi,

you can use CLOB datatype for loading the image.

Thanks

[vamsioracle]

Thanks a lot !

But can i default a folder in pl sql, from where the package should load images. Is there any command for eeting the folder path to access teh image.

[amitpatel66]

Please check Oracle External LOB BFILE Data types for detail