| Want to Store Images inside Database (merged) [message #488782] |
Tue, 11 January 2011 02:44  |
 |
sohailmoon
Messages: 3
Registered: January 2011
Location: Rahim Yar Khan
|
Junior Member |
|
|
//To load an image from the Hard Disk
//Level : Item
//Type : Trigger
//Name : When Button Pressed
Declare
dirname varchar2(25);
v_filename varchar2(25);
Begin
tool_env.getvar('DEMO20',dirname);
dirname:=dirname ||'\bin\bmp';
v_filename:=get_file_name(dirname,NULL,
'All Files (*.*) | *.* |' ||
'JPEG Files (*.jpg) |*.jpg|' ||
'Bitmap Files (*.bmp) |*.bmp|' ||
'TIFF Files (*.tif) |*.tif|' ||
'CompuServe Files (*.gif) |*.gif|' ||
'PC PaintBursh Files (*.pcx) |*.pcx|' ) ;
if v_filename IS NOT NULL Then
read_image_file(v_filename,'any','pic');
end if;
end;
-----------------------------------------
Now what should be the code to store this image from the image box inside the database???
I done a lot of time with Oracle Data Base 11g with the Form Builder 6i and 10g but all in vain . No image store inside the database but browse button work well.
Looking for solution,
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Want to Store Images inside Database (merged) [message #492371 is a reply to message #492370] |
Sun, 30 January 2011 08:42  |
owais_baba
Messages: 289
Registered: March 2008
Location: MUSCAT
|
Senior Member |
|
|
sure & and dont feel hasitate for further question.
DATA TYPE :SYNTAX ORACLE 9i :ORACLE 10g :Oracle 11g
LONG RAW :Maximum size of 2GB.:Maximum size of 2GB.:Maximum size of 2GB.
Explanation(if applicable):-
Variable-length binary strings. (backward compatible)
DATA TYPE :SYNTAX ORACLE 9i :ORACLE 10g :Oracle 11g
BLOB :Store up to 4GB of binary data :Store up to(4
gigabytes -1)*(the value of the CHUNK
parameter of LOB storage).
Store up to (4 gigabytes -1)
*(the value of the CHUNK parameter
of LOB storage).
Explanation(if applicable):-
Stores unstructured binary large objects.
DATA TYPE :SYNTAX ORACLE 9i :ORACLE 10g :Oracle 11g
CLOB :Store up to 4GB of character data :
Store up to (4 gigabytes-1)*
(the value of the CHUNK parameter of LOB storage)
of character data.
Store up to (4 gigabytes -1)*
(the value of the CHUNK parameter
of LOB storage) of character data.
Explanation(if applicable):-
Stores single-byte and multi-byte character data.
i hope u got everything
thanks
[Updated on: Sun, 30 January 2011 08:55] Report message to a moderator |
|
|
|
| Re: Want to Store Images inside Database (merged) [message #492387 is a reply to message #492370] |
Sun, 30 January 2011 13:06 |
owais_baba
Messages: 289
Registered: March 2008
Location: MUSCAT
|
Senior Member |
|
|
sure dear
my question is to you which version of database are you using
2nd are you accessing or saving data from client side i meant to say are you on LAN/WAN if yes what is your server and your system configuration. and who has designed your database. it should not be happened let me give u some Tips.
most websites, content is stored in a database and served to visitors upon request. Databases are very fast, but there's lots of things that you can do to enhance its speed and make sure you won't waste any server resources. In this article.
This first tip may seems obvious, but the fact is that most database problems come from badly-designed table structure.
For example, I have seen people storing information such as client info and image info in the same database column. For both the database system and developers who will have to work on it, this is not a good thing.
When creating a database, always put information on various tables, use clear naming standards and make use of primary keys.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
