Hi all
Somebody plz help me.. How to store/retrieve images from the oracle8i table.
I tried using the article BLOB in this forum.. It works for SQLServer, But I want to know how to implement in Oracle. I tried that article, am getting error that Object or Block variable not set. - CN.Open "Provider=MSDAORA.1;Password=manager;User ID=system;Persist Security Info=True"
The above is the connection string I have given.
My table name is emps;
It has empid,empname, empimage as columns.
I want to store and retrieve images from oracle.
Somebody help me plz..
Its very urgent.
I tried several articles by using Binary File datatype, LOB etc., But still am stuck with it.
Give me an earliest response plz
Thanks in advance.
7 1995
try to use BLOB or LONG RAW for the datatype .
from VB use AppendChunk and GetChunk method of recordset object.
Find methods of Savingimage and RetrivingImage.
Hi
thanks
As I told earlier, I have already tried these articles. Those articles are working only for SQLServer but not for Oracle...
I tried by changing only the connection string but it saying error that Object or With Block variable not set at RS.Open strSQL, CN, adOpenForwardOn ly, adLockReadOnly
Thanks.
Hi
http://support.microso ft.com/kb/185958
I took a reference with the above link..
Its working for inserting images.
But I couldnt insert multiple images into the database....
It works only with storing single images
Help me plz
QVeen72 1,445
Recognized Expert Top Contributor
Hi,
You can Store Single Image in a Column, that is One Record=1 Image.
In Same Record and column, you cannot store Multiple Images, even if you find the logic to save, your Save and Retrieve processes will become very complicated.
If you want a Group of Images to be stored, then Create one Master Table and a Detail Table (Linked by PK), generate a PK and add multiple records in Detail table.
Whenever you want a set of Image, Refer to all records from Detail Table
Regards
Veena
But I couldnt insert multiple images into the database....
It works only with storing single images
Are you trying to insert multiple images to the single row of a table ?
Hi,
You can Store Single Image in a Column, that is One Record=1 Image.
In Same Record and column, you cannot store Multiple Images, even if you find the logic to save, your Save and Retrieve processes will become very complicated.
If you want a Group of Images to be stored, then Create one Master Table and a Detail Table (Linked by PK), generate a PK and add multiple records in Detail table.
Whenever you want a set of Image, Refer to all records from Detail Table
Regards
Veena
Hey am not saying like storing images in a single column. I want to insert one after another as different rows..
Like inserting multiple records.
Thanks for your reply...
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Jean Pierre Daviau |
last post by:
for (var i=0; i< document.images.lenght; i++){
totalWidth = totalWidth + document.images.width;
totalHeight = totalHeight + document.images.height;
}
--
X trême newbe
.......
masm32
windows Xp
|
by: José Checa Claudel |
last post by:
Hello all.
I have a function in PHP to retreive a BLOB field in Oracle DB who has a
JPEG image in it; but I don´t know how show it in an html page with text
information, I have something like this, but doesn´t work properly:
<table border=0 cellPadding=15 cellSpacing=15 height=20 width="100%">
<tr WIDTH="100%" HEIGHT="100%">
<td class="T10a" valign="top">
|
by: RichG |
last post by:
I have an Access database/forms application that has images stored in
it. I need to develop a new VB that utilizes Oracle or the file
system as the underlying storage for these images. In order to do
this I need to retrieve and save the images to disk in their native
format.
The problem is that the images are stored in Access as the OleObject
type rather than binary. I cannot figure out how to pull these
imagesfrom the database and...
|
by: K. A. |
last post by:
I'm trying to write a web site for storing staff ID's together with
their photos using a PHP form. A user of the site should be able to
enter his ID, name, and select a file from a directory as his personal
photo.
Step 1. Created the table in SQL.
SQL> create table file_test (
StaffID number(5) NOT NULL,
StaffName VARCHAR2(30),
Staff_pic bFile);
|
by: Big George |
last post by:
I'm developing with ASP.NET, VS.NET 2003.
Using Crystal Report for VS.NET
DataBase: Oracle 10g
I store a BLOB field in a table. This field store images, like jpg
files.
The Stored Procedure that I use to fill the report is:
OPEN MyCursor FOR
| |
by: satishmovva |
last post by:
Hi EveryOne....
Is there any one to pull out from the following problem. I have a small problem in my project, i want to store my clients images along with their data in my database (oracle 9i) through frontend (VB6.0). After saving the image and data of my clients again i want to get report from Crystal Reports which contains the client information along with his/her image. Please guide me to solve this problem ASAP.
Bye
Satish Kumar. M
|
by: Harshadcode |
last post by:
Hi,
This is HARSHAD,
I am creating a project in VB.NET
for managing details like photos of criminals.
but i am facing problems in converting a image in to filestream so that it can be inserted in to the oracle 10g database using BLOB variable type.
if you can help me it will be very helpful..
This is my code:
---------------------------------------------------------------------
Imports System
|
by: Kingsway |
last post by:
How do i upload JPEG images to Oracle. Not possible to EMBED images into spreadsheet. I know SQL Laoder can do the job but not suree how to EMBED JPEG images to Excel or TXT file.
|
by: vamsioracle |
last post by:
Hi All
I want to load images into Oracle 9i database.
My package should automatically load from a predefined folder on my sytem and load into database. Is there any possibility to set the physical location path on local system and to load into the database.
Thanks in advance
vamsi
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |