Home » SQL & PL/SQL » SQL & PL/SQL » Load/insert image/picture files into oracle 7.0.3
Load/insert image/picture files into oracle 7.0.3 [message #8995] Thu, 09 October 2003 11:58 Go to next message
Amarsey
Messages: 17
Registered: March 2002
Junior Member
Hello there!
Can somebody help me with a sample code or procedure as to how to insert pictures into a table
my_image(image_id varchar2(10) image_name long raw).
I have a lot of pictures i need to assign to each student in a database that already has a lot of records in it. I am using oracle version 7.0.3
I have tried that through forms 6i but that one is not fast since i have to insert an image one at a time.
Thanks.
Re: Load/insert image/picture files into oracle 7.0.3 [message #9017 is a reply to message #8995] Fri, 10 October 2003 23:03 Go to previous messageGo to next message
Abul Fazal
Messages: 39
Registered: February 2002
Member
If U are using Oracle 8 & higher, save it in the OS & use a BFILE data type to point to the file.
Re: Load/insert image/picture files into oracle 7.0.3 [message #205570 is a reply to message #9017] Sun, 26 November 2006 03:31 Go to previous messageGo to next message
matrik02
Messages: 64
Registered: November 2005
Member
Can somebody tell me, the step to load picture into Oracle? I don't know how to create it
Re: Load/insert image/picture files into oracle 7.0.3 [message #205571 is a reply to message #205570] Sun, 26 November 2006 03:37 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Frank already pointed you to the right direction, but it seems that you're just too lazy to follow the path.

Don't expect to be spoonfed and don't open the same question all over the Forum.
Previous Topic: procedure is advantageous than trigger ? Urgent
Next Topic: how store picture image in Oracle database
Goto Forum:
  


Current Time: Thu Mar 28 16:06:41 CDT 2024