Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

A Quick Question - How can i store images on database?

951671Feb 12 2013 — edited Feb 12 2013
Hi all,

I'm a newbie on oracle techs. I need to store images on database. I created a table and selected "BLOB" type for image column. But i have some errors just like this :


oracle.jbo.domain.BlobDomain type, ‰PNG

IHDRÑT…¥´… pHYsšœ OiCCPPhotoshop ICC profilexÚ�SgTSé=÷ÞôBKˆ€”KoR RB‹€‘&*! Jˆ!¡ÙQÁEEÈ ˆŽŽ€ŒQ,Š Øä!¢Žƒ£ˆŠÊûá{£kÖ¼÷æÍþµ×>ç¬ó�³ÏÀ–H3Q5€©BàƒÇÄÆáä.@� $p³d!sý#ø~<<+"À¾xÓÀM›À0‡ÿêB™\€„Àt‘8K€@zŽB¦@F€�˜&S `ËcbãP-`'æÓ€�ø™{[”! ‘ eˆDh;¬ÏVŠEX0fKÄ9Ø-0IWfH°·Àβ0Qˆ…){`È##x„™FòW<ñ+®ç*x™²<¹$9E�[-qWW.(ÎI+6aaš@.Ây™2�4àóÌ ‘àƒóýxήÎÎ6޶_-ê¿ÿ"bbãþåÏ«p@át~Ñþ,/³€;€mþ¢%îh^ u÷‹f²@µ éÚWópø~<<E¡�¹ÙÙåääØJÄB[aÊW}þgÂ_ÀWýlù~<ü÷õà¾â$�2]�GøàÂÌôL¥Ï’ „bÜæ�Gü·ÿüÓ"ÄIb¹X*ãQqŽDšŒó2¥"‰B’)Å%Òÿdâß,û>ß5°j>{‘-¨]cöK'XtÀâ÷ò»oÁÔ(€hƒáÏwÿï?ýG %€fI’q^D$.Tʳ?ÇD �*°AôÁ,ÀÁÜÁü`6„B$ÄÂBB d€r`)¬‚B(†Í°*`/Ô@4ÀQh†“p.ÂU¸=púažÁ(¼� AÈa!ÚˆbŠX#Ž™…ø!ÁH‹$ ɈQ"K‘5H1RŠT UHò=r9‡\Fº‘;È2‚ü†¼G1”�²Q=ÔµC¹¨7„F¢Ðdt1š� ›Ðr´=Œ6¡çЫhÚ�>CÇ0Àè3Äl0.ÆÃB±8, “c˱"¬«Æ°V¬»‰õcϱw�EÀ 6wB aAHXLXNØH¨ $4Ú 7 „QÂ'"“¨K´&ºùÄb21‡XH,#Ö�/{ˆCÄ7$‰C2'¹�I±¤TÒÒFÒnR#é,©›4H#“ÉÚdk²9”, +È…ä�äÃä3ää!ò[ �b@q¤øSâ(RÊjJåå4åe˜2AU£šRݨ¡T5�ZB­¡¶R¯Q‡¨4uš9̓IK¥­¢•Óhh÷i¯ètºÝ•N—ÐWÒËéGè—èôw
†ƒÇˆg(›gw¯˜L¦Ó‹ÇT071ë˜ç™™oUX*¶*|‘Ê •J•&•*/T©ª¦ªÞªUóUËT�©^S}®FU3Sã© Ô–«Uª�PëSSg©;¨‡ªg¨oT?¤~Yý‰YÃLÃOC¤Q ±_ã¼Æ c³x,!k
«†u�5Ä&±ÍÙ|v*»˜ý»‹=ª©¡9C3J3W³Ró”f?ã˜qøœtN ç(§—ó~ŠÞï)â)¦4L¹1e\kª–—–X«H«Q«Gë½6®í§�¦½E»Yû�AÇJ'\'Gg�Î�çSÙSݧ §M=:õ®.ªk¥¡»Dw¿n§î˜ž¾^€žLo§Þy½çú}/ýTýmú§õGX³$ÛÎ<Å5qo</ÇÛñQC]Ã@C¥a•a—á„‘¹Ñ<£ÕF�FŒiÆ\ã$ãmÆmÆ£&&!&KMêMîšRM¹¦)¦;L;LÇÍÌÍ¢ÍÖ™5›=1×2ç›ç›×›ß·`ZxZ,¶¨¶¸eI²äZ¦Yî¶¼n…Z9Y¥XUZ]³F­�­%Ö»­»§§¹N“N«žÖgðñ¶É¶©·°åØÛ®¶m¶}agbg·Å®Ã“}º}�ý=
‡Ù«Z~s´r:V:ޚΜî?}Åô–é/gXÏÏØ3ã¶Ë)Äi�S›ÓGgg¹sƒóˆ‹‰K‚Ë.—>.›ÆÝȽäJtõq]ázÒõ�›³›Âí¨Û¯î6îiî‡ÜŸÌ4Ÿ)žY3sÐÃÈCàQåÑ?Ÿ•0k߬~OCO�gµç#/c/‘W­×°·¥wª÷aï>ö>rŸã>ã<7Þ2ÞY_Ì7À·È·ËOÃož_…ßC#ÿdÿzÿѧ€%g‰�A�ûøzpy¡ÎÂô…§©.,:–@LˆN8”ðA*¨Œ%òw%Ž yÂÂg"/Ñ6шØC\*NòH*Mz’쑼5y$Å3¥,幄'©�¼L
LÝ›:žšv m2=:½1ƒ’‘�qBª!M“¶gêgæfvˬe…²þÅn‹·/•Ék³�¬Y- ¶B¦èTZ(×*²geWf¿Í‰Ê9–«ž+Íí̳ÊÛ�7œïŸÿíÂá’¶¥†KW-X潬j9²<qyÛ ã+†V¬<¸Š¶*mÕO«íW—®~½&zMk�^ÁÊ‚ÁµkëU å…}ëÜ×í]OX/Yßµaú†�>‰Š®Û—Ø(Üxå‡oÊ¿™Ü”´©«Ä¹dÏfÒféæÞ-ž[–ª—æ—n
ÙÚ´
ßV´íõöEÛ/—Í(Û»ƒ¶C¹£¿<¸¼e§ÉÎÍ;?T¤TôTúT6îÒݵa×ønÑî{¼ö4ìÕÛ[¼÷ý>ɾÛUUMÕfÕeûIû³÷?®‰ªéø–ûm]­NmqíÇÒý#¶×¹ÔÕÒ=TR�Ö+ëGǾþ�ïw-
6
U�œÆâ#pDyäé÷ ß÷
:ÚvŒ{¬áÓvg/jBšòšF›Sšû[b[ºOÌ>ÑÖêÞzüGÛœ4<YyJóTÉiÚé‚Ó“gòÏŒ�•�}~.ùÜ`Û¢¶{çcÎßjoïºtáÒEÿ‹ç;¼;Î\ò¸tò²ÛåW¸Wš¯:_mêtê<þ“ÓOÇ»œ»š®¹\k¹îz½µ{f÷éž7ÎÝô½yñÿÖÕž9=ݽózo÷Å÷õßÝ~r'ýÎË»Ùw'î­¼O¼_ô@íAÙC݇Õ?[þÜØïÜjÀw óÑÜG÷…ƒÏþ‘õ�C�™�ˆ
†ëž8>99â?rýéü§CÏdÏ&žþ¢þË®/~øÕë×Îјѡ—ò—“¿m|¥ýêÀë¯ÛÆÂƾÉx31^ôVûíÁwÜwï£ßOä| (ÿhù±õSЧû“““ÿ˜óüc3-Û cHRMz%€ƒùÿ€éu0ê`:˜o’_ÅFV®IDATxÚì]g˜TEÚ=UuCçîÉ�%ˆd1 ˆ9爻f]s\sÜ]Űº‹Š9`(b ¨¨ä† 0y:ßPUß�îšvL»î·Ûçyú™aè®{ë­ÛUïy#‘R"‹,²È"‹,²È"‹,²È"‹,²Ø;ÈïqÑŠŠ2òŸ*�íÛ«³V…,²È"‹1Þ|óMÀ¥išn÷z=j^^ž‹ªÆã1€dŒÉp8�F£qÆÓçõ"Áçõñá#Fð¬³È"‹,²È"‹ÿj�AœÉïMäÓ Ûû=K¦³È"‹,~[Ì›7�ååæj p¹\î€ÛíΓR:LËš¦©º¦1!$±¹-�x\RÆ i—BÄ-Û6Æ@(%¦a˜¦a…Á`0?~‚••nYd‘EYdñ_E¢Ó4I{¡�ßò,Ûù]f‰tYd‘ůÇÇDþ€ÏíõøuM÷ !\6·�‚s�RªI)©”R†B!ât:áöx ¥„eYhin†Ëå‚¢ª"‹IJ)4M¥Thšf3…™†a´Ä£±`( µ´¶†;ì03+õ,²È"‹,²Èâÿ5‰N#Ð4y=šñ{&±þw’èÔKd¼²D:‹,²ÈâWâåW^aô/w»ÜeB W¨5¨´ƒ,�P˲ ( <n|>%¨­©�®ë‰—¦£µµqÓ„Ûå‚i˜ˆÆb(*,„îp€R‡Ó J™
)-)…)„Fc±ú`kkã¨Qų+�EYd‘EYü¿#Ñš`”ŒŸé¤úßI ÓI3`'_<ù’d–Dg‘EYü||üñG´sç.�§çÜmÙ5–i!�#¡¥¥–eÁíñÀãvCUlÙ²„QH!¡k*,›Ãçó"�¡¾®…اKgD£QPJát:¡iœ.—ÔuW(5âñxSSssmccc‹ª*æøñ²ûxYd‘EYdñŸO¢Û!Ð 5ùÒ’?•ä+Ý#ý¯&Ï©Ÿ)²l¥½Ì2�õFg‘EYüLÌŸÿ1-*.Îõy}]UU)´,\pbš&Âá0Z[[ÁmápáHF<Žp8]סª*6lØ€¼¼<†ŸÏ‡â’b8t~X¾RôêÕªª ®®·Å%Å(..�Çë�ª( „ÚbBˆPuuõ¶êššæ£fÌÈ"Ë"‹,²È"‹,~(ÿb� ÙfIÒ¬p$_ºÇãuX–¥¨Š¢J)¤È¿„H'I0I†iAá”R“1fªªjÄbÑhkkKÊ3�"ôYòœEYdñ3°ð³Ô繜ΔQ¿Í9¸R�X,†ššZlÞ¼---`”‚) rr…BøüóÏQVVEU±~ýz¸\.466‚Rо}ûÀãqcóæÍð(,(@uM5B¡Š‹‹Ñ»WotîÔ >¿N§S!„xUUõ—û)¥ëçÍ›·ãˆ#ް³+”EYd‘Åÿ&<þ‰Â+P)všç¦j0‹n·ëèÈr8tPë”þ=²\ç?‰Dgè”Zààà:åÔó‡^}Õ¥z<Nçï-„ªê�ëg?6ûôüãñõøq±³ìÕEYdñðÁïÓ‚¢¢"ŸÏ×á;ü „@È ‘µµ¨©Ù�H8Ó0‡@ASc4]Cn^.~X¾}úôF<x<ÔÖÖ"//yyyغe+Zš[ k:¡06oÚ„ÚÚZBàv»¡ê(c`”°¡*Š»´´d_�Çí_¼xÑ–-[·ÅŽ?î¸ì¾žEYd‘ņýeQ Þ -(#Ö±:QFŒH¦QÚ([hu뺨ýíÚèº!µß¼õè[ó·Ÿø„–¬äþHtÒÝžÚ ÀÀÓ¹K÷ÂK/½èöÿ E£~øñÝÿøÇãÕø} œe‘EYü¿Ç‹/¾DŠ‹Kòü>ß>.—Ë‹ÅdSS±sg=vìÜ�†úzÒÜÜ)%LÓD,eùùùؼi#¤� „`ýºõØwß}Q_W!˜Â ‡�Ÿ—‡ü‚ÔTWˆÆb¨­ÝÆrsóPVZŸÏMÓ@T€s€¢y½Þ}lÛÖ;WT¬É®XYd‘Eÿ-˜óîj²¤�[eØg9©î'$OäX:@@ ‘n"­¨[·¬<�i´°}¯lË–×ÄfÞóü#tÛpÙÁòiO¿‰N#Ð»Š‡¥h_§N]‹î¿ÿákrsüù¿÷äm›‹/¾\ôÐM7^õÚ©Ì�¬:‹,²Èâ§íÿåe¾¼ÜÜΚ¦åÖ×דÚÚ2#¢¡±õuuhjnB0„e˜h
‰D@A8Faa!V®\ B,ËB]ÝN€e™ˆF¢X±|†Žœ@555XþÃrøý>pÎŽD°vÍZäç#77š¦BñûAƒ”RJp!H^^~™®éü›o¾Þ0tèþÑìªe‘EYdñÿ/}¸�ÕÆè—jÿÁÏÙA6a^Fi€6±A´¡q)NAý¢Ë5BýbyxÒ7[—uÚ½Ï=ûÌå'Vf%úÓÀ~c
ì^…;•íàs¹=9·Þv×™£Ü<¥ôwõør.ä÷߯üì´S�{HJ` Q\,UTLÙ¢bYd‘E{Ç~ wêÜ©¡´´µ5H#‘(% „¢¥µµ;v’––D#QÄãq7X–…x<Žh4ŠH$‡CGAA>ššš ( „¥p8��B ¡¾ñx𮡲rª««A…m[¿ßŸ8Ôc ü~?TU…Í9ŒxœóDÈ·ÇãáœGŽ<òÈÈœ9sDvõ²È"‹,²øÿŠKÿ¹Æ©*ÚQ†�WÕ›bxØ–F (¥% ‰–�ŒD¢1†eÆ U�èZ®Ðy1ªu±#bàºÍ
:ÛzÛ�·n~çÙ§²üçßE¢ý~_¦ZK’h/ß¹\<ú¸c�:K×4ö{O|ó–í[®¾æÊvÔV7ˆ'_©êÜ)�4‚ÁPö)É"‹,²èŸ~ú©³¬¼¼@:…#aÕ4Mép8 „$5µµØ¸iêëÑÔÜ„æ¦&[ƒ$�Áæ6âñ88PÃ0 krrs % *”1ñ8"‘B¡0êêêáõz!8‡�

.....


How i can handle this problem?

Any help will be appreciated.

Erdo

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 12 2013
Added on Feb 12 2013
6 comments
197 views