Home » Other » General » how to store images in oracle database?
how to store images in oracle database? [message #103460] Thu, 16 October 2003 06:05 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: how to store images in oracle database? [message #103968 is a reply to message #103460] Mon, 07 June 2004 04:05 Go to previous messageGo to next message
raamalakshmi
Messages: 1
Registered: June 2004
Junior Member
how to stode blob item in oracle and how to retrive it
how to store images in oracle database? [message #103998 is a reply to message #103798] Sun, 20 June 2004 08:47 Go to previous messageGo to next message
kshama
Messages: 1
Registered: June 2004
Junior Member
i want to store image in oracle 9i database ,
can anyone give help on this topic.........
Re: how to store images in oracle database? [message #104046 is a reply to message #103998] Fri, 09 July 2004 22:31 Go to previous messageGo to next message
faiz
Messages: 3
Registered: December 2002
Junior Member
hello
Re: how to store images in oracle database? [message #104314 is a reply to message #103798] Wed, 15 September 2004 06:55 Go to previous messageGo to next message
abid
Messages: 6
Registered: December 2003
Junior Member
i want the code to store the image in the oracle
Re: how to store images in oracle database? [message #104558 is a reply to message #104314] Sat, 27 November 2004 02:42 Go to previous messageGo to next message
Chakravarthy
Messages: 8
Registered: November 2000
Junior Member
Sir/Madam

Looking forward the code...

thanks in advance

Cheers
Chakri From Vizag
Successfully Stored Pictures in Oracle Dbase. [message #104577 is a reply to message #104314] Fri, 03 December 2004 02:02 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: how to store images in oracle database? [message #104638 is a reply to message #103968] Tue, 21 December 2004 06:10 Go to previous messageGo to next message
Nivethitha
Messages: 1
Registered: December 2004
Junior Member
hi

may I know how to store the sin waves in a data base.
Re: how to store images in oracle database? [message #109613 is a reply to message #103798] Sun, 27 February 2005 00:44 Go to previous messageGo to next message
Shriram
Messages: 1
Registered: February 2005
Junior Member
Hello,
I have arround 500 files of image which i want to store from backend in LONG RAW Datatype. Please tell me how to store it.
Re: how to store images in oracle database? [message #110290 is a reply to message #109613] Fri, 04 March 2005 20:22 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:232814159006#6891533553691
Previous Topic: ORA 1036 - Oracle 8
Next Topic: OleDB for Oracle Database 8.1.5
Goto Forum:
  


Current Time: Mon Sep 27 00:07:30 CDT 2021