abdallah1973
asked on
Store code inside oracle BLOB column
Dear all,
I am try to use the below code to insert picture inside oracle table using SQL Plus to be display on crystal report.
insert into timeta(ID,BEIMAGE) values(1283,utl_raw.cast_t o_raw('C:\ photo_dir\ test2.png' ));
but it's not show anything in the crystal report.This is the first time I use to store image in BLOB field and I am not sure if I am do it right.
Can you please advice?
I am try to use the below code to insert picture inside oracle table using SQL Plus to be display on crystal report.
insert into timeta(ID,BEIMAGE) values(1283,utl_raw.cast_t
but it's not show anything in the crystal report.This is the first time I use to store image in BLOB field and I am not sure if I am do it right.
Can you please advice?
You use DBMS_LOB.LOADBLOBFROMFILE the file you load needs to be on the database server.
If you want to load the file from a remote client you can write custom code or use SQL Loader (if you installed the tools when you installed the client software).
If you want to load the file from a remote client you can write custom code or use SQL Loader (if you installed the tools when you installed the client software).
What version of Crystal are you using?
mlmcc
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The version is 2008 and it's work fine. Than you all.
With CR2008 you don't need to store the picture in the database. You can just store the full path and file name.
mlmcc
mlmcc
ASKER
I test and enhance it to me my requirements. The knowledge is taken from your portal.
I believe what you are looking for is DBMS_LOB.LOADBLOBFROMFILE.
I would recommend searching around the web for example code.