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

fac586

The item in this case opens up a small modal page that has the data to be selected. The question now is, the same item and function exists in Oracle APEX, and it has an option to choose between "modal dialog" and "inline". Is there a way to set this in the parameters given to the item?
Is there a way to achieve this multiple search in this custom apex_item.popup_from_lov?
In both cases, the answer is "no". The terms "popup" and "LOV" are all these things share. They are completely different components with totally separate implementations.
Here's how it looks
It looks a bit odd. What APEX version and theme are you using?
Please don't crop screenshots. Show the entire browser window to provide some background context.
Basically this doesn't look like a viable long-term solution. The apex_item API is considered a legacy feature and is not recommended for use in new applications, and the Popup LOV template has just been desupported in APEX 22.1.
I would suggest that you provide an expanded description of your requirements to enable us to suggest a better approach.

Andreas Wildmann

Sorry, I was worried about not showing anything data related.
Here is a full screen of the page. My Apex version is 21.2, and the theme is just a css color choice.
The reason for implementing this html generated through the PLSQL procedure is because the idea is to have a report with these "cards" to show, and we want to be able to set what the amount of lines and columns we can have. I've attempted the same with the classic report cards, but the settings to select the amount of columns is limited to what we would like. Only having the options to have a 1, 2, or 5 columns doesn't quite work.
Another issue with using the classic report cards is that, the apex_item generated inside it, even though able to be selected as if to type something in it, acted as a read-only, and there wasn't any way to enable writing in the item.
image.png

fac586

What problem are you actually trying to solve here?
That's not a UI that I would ever consider creating, which leads me to suspect that everything else about this would be equally alien to me.

Andreas Wildmann

Sorry I haven't been presenting the problem properly.
I would like to, if the component is capable of doing so, to have each of these little boxes to have a apex_item.popup_from_lov item (generated through the PLSQL procedure) that opens a window like this, where you can type some information related to what you might be looking for, and the results adjust themselves, rather than having a single column to search.
image.png

fac586

I would like to, if the component is capable of doing so, to have each of these little boxes to have a apex_item.popup_from_lov item (generated through the PLSQL procedure) that opens a window like this, where you can type some information related to what you might be looking for, and the results adjust themselves, rather than having a single column to search.
No, that's not possible using apex_item.popup_from_lov. It is based on legacy LOVs with 2 display/value columns.
I don't understand what you mean by "the results adjust themselves"?
Why have 50 of them?
What source(s) of data are being queried? Is it the same for all of the items?
What happens next?

Andreas Wildmann

The reason for wanting the several columns popup_from_lov is mostly to do giving our users the most options when performing a search. They might remember the description of the entries they are looking for, but sometimes they may want to search for the phone number linked to that description, for example.
The data sets are separate into, mostly, a description, 2 other columns of information, and a phone number. When they typed data matching any of these, they could then select the one they wanted, which then would fill up the boxes shown above.
Using the example I from this "Employee" from the proper apex component popup_from_lov, I would search for Allen and a choice of data would be displayed in the "card".
image.pngThe idea would be to replicate the display in the popup_from_lov, but in the apex_item variant. It's a shame it's not possible then, I might have to look into other options. Thanks for the clarification, fac586!

1 - 6
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
196 views