Blob

[amoldiego]

Hi,
Could u please send information about BLOB datatype. I searched in Google but couldnot able to find out what i required.

Please send some coding related to BLOB datatype means from starting(create directory onwards)...

Also mentioned how to handle BLOB ...how to insert in BLOB datatype
What is DBMS_LOB.INSTR ,DBMS_LOB.READ

Thanks .

[amoldiego]

Blob

Hi,
Could u please send information about BLOB datatype. I searched in Google but couldnot able to find out what i required.

Please send some coding related to BLOB datatype means from starting(create directory onwards)...

Also mentioned how to handle BLOB ...how to insert in BLOB datatype
What is DBMS_LOB.INSTR ,DBMS_LOB.READ

Thanks .

[debasisdas]

Create the directory inside Oracle when logged on as SYS ,since normal user does not have the previleges to create directory

create or replace directory mydir  as 'd:\data\'

then grant read and write on the directory to that user

grant read on directory mydir to user_name;