473,581 Members | 2,786 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Oracle CLOB

Gox
Hi.

This is my situation:

Backend: Oracle 8i
Frontend: MS Access 2k (ODBC driver support LOBs)
Q: How insert (upload) a CLOB (pdf or doc file) to an Oracle using MS
access (form)??
Q: How display (download) a CLOB (pdf or doc file) from Oracle using MS
access (form)??

Any example or hint???
Thx!!
Nov 16 '06 #1
3 9046

Gox wrote:
Hi.

This is my situation:

Backend: Oracle 8i
Frontend: MS Access 2k (ODBC driver support LOBs)
Q: How insert (upload) a CLOB (pdf or doc file) to an Oracle using MS
access (form)??
Q: How display (download) a CLOB (pdf or doc file) from Oracle using MS
access (form)??

Any example or hint???
It sounds like you want to store the documents as OLE Embedded Objects
within the Oracle database. If so, then don't use CLOB columns. They
are for storing character data and usually appear in Access linked
tables as "Memo" fields.

Instead, use BLOB columns. They are for storing binary data and appear
in Access linked tables as "OLE Object" fields.

Nov 16 '06 #2
Gox
Gord wrote:
Gox wrote:
>Hi.

This is my situation:

Backend: Oracle 8i
Frontend: MS Access 2k (ODBC driver support LOBs)
Q: How insert (upload) a CLOB (pdf or doc file) to an Oracle using MS
access (form)??
Q: How display (download) a CLOB (pdf or doc file) from Oracle using MS
access (form)??

Any example or hint???

It sounds like you want to store the documents as OLE Embedded Objects
within the Oracle database. If so, then don't use CLOB columns. They
are for storing character data and usually appear in Access linked
tables as "Memo" fields.

Instead, use BLOB columns. They are for storing binary data and appear
in Access linked tables as "OLE Object" fields.
Ok, I'll use BLOB column.
Do you have any example (VBA code) for inserting BLOB into Access linked
table??
Nov 16 '06 #3

Gox wrote:
Gord wrote:
Gox wrote:
Hi.

This is my situation:

Backend: Oracle 8i
Frontend: MS Access 2k (ODBC driver support LOBs)
Q: How insert (upload) a CLOB (pdf or doc file) to an Oracle using MS
access (form)??
Q: How display (download) a CLOB (pdf or doc file) from Oracle using MS
access (form)??

Any example or hint???
It sounds like you want to store the documents as OLE Embedded Objects
within the Oracle database. If so, then don't use CLOB columns. They
are for storing character data and usually appear in Access linked
tables as "Memo" fields.

Instead, use BLOB columns. They are for storing binary data and appear
in Access linked tables as "OLE Object" fields.
Ok, I'll use BLOB column.
Do you have any example (VBA code) for inserting BLOB into Access linked
table??
Sorry, no. Try Google.

Nov 16 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
2619
by: freak | last post by:
hi i have problems reading an oracle(9i) clob from a php-script with the MDB-class from pear. the table files has 3 fields: id integer document clob picture clob
0
4262
by: Bryan Jackson | last post by:
Greetings, (I am an Oracle newbie -- been working with SQLServer for quite some time, however. I'm using Oracle9i and Oracle9i JDeveloper v9.0.3.1 (build 1107) for my programming environment). I'm trying to get an Oracle function to return XML to a JSP page, but am having some problems (mostly Oracle errors). Let me start by showing...
5
5322
by: gimme_this_gimme_that | last post by:
In Oracle you can have a statement such as insert into foo (foo_id,some_clob) values (100,empty_clob()) where empty_clob() inserts a clob address. What is the approach in DB2 (8.1) to creating a row having with a CLOB and no contents but with no null?
3
4061
by: premmehrotra | last post by:
I am using Access 2000 and Oracle 9.2.0.x on a Windows 2000. I have setup Oracle 9.2 ODBC Driver (I have not yet figured how to set Microsoft's Oracle ODBC driver). I am exporting a table from Access to Oracle and I get following error: ODBC Call Failed: ORA-12571: TNS Packet Failure Error I see table and its indexes created in Oracle....
3
3439
by: DavidPL | last post by:
Hello, I have some problem with bind method in PDO on Oracle with clob | long column type. I have table named TEST_TABLE where I have two columns: ID (int 10, 0) and TEXT (varchar 4000 or long or clob). When I try execute PHP code (based on example in manual): <?php
5
7221
by: jonceramic | last post by:
Hi All, I started developing in Access, and people took notice and so we're starting to migrate into our corporate's bigger Oracle system. I'll still be using my developed Access front ends, but will be migrating my back ends to Oracle ODBC. 1. Does anyone have recommendations for books or web resources for general...
3
4580
by: egarobar | last post by:
I am using Access 2003 (on WinXP) to read from an Oracle db, where there is a table with a CLOB which is a variable-size text field. In the 'linked table' which is created in the Tables panel of Access, the CLOB becomes a Memo field. I need to create a report that displays the data from this CLOB in the correct format. The data in the CLOB...
1
5197
by: reliance | last post by:
Using Oracle Migration Workbench, I migrated ms-access 2003 database to oracle 9i. The memo datatype in ms-access mapped to clob datatype in oracle. I have created a system dsn to access oracle tables through ms-access so that the front-end will remain in ms-access. While fetching clob datatype fields - I get ODBC error ODBC--call failed. ...
0
2644
by: *Davide* | last post by:
Hello, This query (PHP+Oracle) works: global $user,$pass,$sid; $db_charset = 'UTF8'; $db = OCILogon($user, $pass, $sid, $db_charset); $clob = OCINewDescriptor($db, OCI_D_LOB); $txt_clob = $arguments;
0
7808
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8312
jinu1996
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...
1
7914
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8181
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6564
agi2029
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...
1
5683
isladogs
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...
0
3835
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2309
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
0
1145
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.