| how to store images in oracle database? [message #103460] |
Thu, 16 October 2003 06:05  |
sriram.B
Messages: 1
Registered: October 2003
|
Junior Member |
|
|
hello, experts
please tell me how to store images or photographs in oracle database . i want to do it in my project in which student photographs have to be stored in database for reference purpose.
|
|
|
|
| Re: how to store images in oracle database? [message #103461 is a reply to message #103460] |
Fri, 17 October 2003 03:48  |
BIRENDER KUMAR
Messages: 18
Registered: May 2003
|
Junior Member |
|
|
hi,
U can create a column as long raw datatype.
Use forms for inserting record ie pic in database.
By read_image_file select ur pic and populate it into that items and save it.
As I have tried it ,its working fine
U go thru read_image_file in help and use it.
from,
Birender Kumar.
|
|
|
|
| Re: how to store images in oracle database? [message #103798 is a reply to message #103461] |
Thu, 18 March 2004 00:29 |
omar
Messages: 19
Registered: February 2002
|
Junior Member |
|
|
|
i want to veiw a (gif) image anamated image how can i do it is it work using the read_image_file, i try to import it but its not working, i try to use OLE contaner but it veiw just the first fram, can u help me plz.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Successfully Stored Pictures in Oracle Dbase. [message #104577 is a reply to message #104314] |
Fri, 03 December 2004 02:02 |
Khurram nazir
Messages: 2
Registered: December 2004
|
Junior Member |
|
|
Dear Partner this is the easiest method to store pictures in Oracle Dbase using oracle Developer.
You should work as below.
Step 1).
Create a Table that have "Long raw" Datatype column.
See Exp:
SQL> Create table pk_ocp
SQL> (pic long raw);
Table Created.
Step 2).
Now create a Canvas, Using Oracle Developer.
Run it.
Press: Insert a record (On runing oracle form)
open any picture "right click on the picture" and copy.
Step 3).
On Runing Form go to "Edit" and then paste.
Step 4).
Press Save (On runing oracle form)
Congratulation U've Learn the easiest way to store a picture in the oracle Dbase.
|
|
|
|
| Successfully Stored Pictures in Oracle Dbase. [message #104578 is a reply to message #103998] |
Fri, 03 December 2004 02:06 |
Khurram nazir
Messages: 2
Registered: December 2004
|
Junior Member |
|
|
Dear Partner this is the easiest method to store pictures in Oracle Dbase using oracle Developer.
You should work as below.
Step 1).
Create a Table that have "Long raw" Datatype column.
See Exp:
SQL> Create table pk_ocp
SQL> (pic long raw);
Table Created.
Step 2).
Now create a Canvas, Using Oracle Developer.
Run it.
Press: Insert a record (On runing oracle form)
open any picture "right click on the picture" and copy.
Step 3).
On Runing Form go to "Edit" and then paste.
Step 4).
Press Save (On runing oracle form)
Congratulation U've Learn the easiest way to store a picture in the oracle Dbase.
if found any problem reply me at my e-mail address.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
