OraFAQ Forum: Forms » how to insert images and to view them SQL Plus and Forms 6i

Home » Developer & Programmer » Forms » how to insert images and to view them SQL Plus and Forms 6i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to insert images and to view them SQL Plus and Forms 6i [message #170837]

Fri, 05 May 2006 07:51

laughter_master
Messages: 1
Registered: May 2006

Junior Member

Hello

I'm trying to create a database for an assigment and am required to save jpeg images to oracle 10g using SQL Plus and a way of viewing these in Forms 6i.

Can anyone suggest how I can go about doing this.

I have tried searching OraFAQ and most of the topics mention BLOBS - can someone please explain what this is. Thanks

Laughter_master

Report message to a moderator

Re: how to insert images and to view them SQL Plus and Forms 6i [message #170905 is a reply to message #170837]

Sat, 06 May 2006 00:28

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Please google 'blog' for a fuller explanation. A blog is a 'binary long object'. Basically, its an object type for storing large binary objects.

I don't know how to store an image via SQL*Plus but there are plenty of threads. Have a look at http://www.orafaq.com/forum/m/136906/67467/?srch=read+jpg#msg_136906

David

Report message to a moderator

Re: how to insert images and to view them SQL Plus and Forms 6i [message #170946 is a reply to message #170905]

Sat, 06 May 2006 10:06

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Huh, don't google for BLOG; try BLOB instead Wink

as "blog" is short for weblog, while "blob" means binary large object - image, for example.

Report message to a moderator

Re: how to insert images and to view them SQL Plus and Forms 6i [message #171040 is a reply to message #170946]

Mon, 08 May 2006 01:39

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Woops, brain fade. Yea, BLOB - it certainly makes a better acronym for Binary Long Object.

David

Report message to a moderator

Previous Topic:	how use Esc ,F2,F1 button in my form
Next Topic:	navigation trap

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:53:46 CDT 2024