Hello Y’all, How do I store about 695 signs inventory photo images from a PDF file to an Oracle database table? We are using Oracle 10.2.0.2. What data type should I use for these images? How about the table space? What table space should I allocate to ensure there is no space issue? Thanks in adv…

Toad can help you load the data. One at a time, by inserting a BLOG object to a record field by pointing to the source file. That will get tiring and you have 700 to load, you probably want to look at SQLLDR – I THINK it supports BLOB/FILE uploads [image] Loading LOB Data Using SQL*Load…

I meant BLOB, not BLOG, but Toad can help you with that too J http://www.youtube.com/watch?v=iahTXSXLgbM

the microsoft active-view opened a tiny window literally 50pixel high by 50 pixel wide window that was neither interactive (you pressed escape to no avail) and did not allow configuring…(operator cannot resize the window) you may want to repackage your active view presentation as a shockwave fil…

Thanks for the helpful information Jeff. You wrote: Toad can help you load the data. One at a time, by inserting a BLOG object to a record field by pointing to the source file. How? Please advise! Thanks. You wrote: you probably want to look at SQLLDR - I THINK it supports BLOB/FILE >uploads…

Sorry Jeff, I couldn’t view the youtub because our department has this web site blocked. Thanks anyway.

You double-click in the grid to edit the BLOB record, then use the ‘Open File’ dialog to point to your image. how to get each photo image from the PDF file to a sign file Sounds like a good question for someone who’s an ADOBE/PDF expert or Google.

Thanks Jeff. I tried your suggestion the way I understand it, but the stored images would not display. Please review the following and see if you could figure out what’s missing: DROP TABLE test_lob_tab; CREATE TABLE test_lob_tab ( photo_id NUMBER(16), blob_content BLOB ); INSERT INTO test_lob…

To view it, you have to save it back to file, then open it.

How to store photo images in an Oracle database table?

Toad for Oracle & DevOps Toolkit

HillbillyToad March 19, 2011, 10:20am 12

Sounds like a good idea to just show the image natively though

Topic		Replies	Views
How to store photo images in an Oracle database table? Toad for Oracle & DevOps Toolkit	0	375	March 22, 2011
Using Oracle Database 12c Service PDBs on Oracle Cloud Platform with Toad for Oracle - Part II Blog Posts	0	656	November 8, 2018
TDP conversion issue Toad Data Point & Toad Intelligence Central	35	4050	February 13, 2015
Update BLOB from a file Toad for Oracle & DevOps Toolkit	7	498	October 15, 2024
How to load a picture into a certain BLOB field ? Toad for Oracle & DevOps Toolkit	1	2053	January 5, 2010

How to store photo images in an Oracle database table?

Related topics