| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: Oracle DB - Appending via Access
Dick,
Even prior to posting a message to this list I had checked if any constraints were present in any way. But I checked again as it would seem the likely senario and no constraints on this field were found in either program. But it does only throw an error when the field is updated or appended to a null value via access. Yet it allows it via sql*plus.
At this point, a quick (dodgy) fix might be in order.
Thanks,
renée
-----Original Message-----
dgoulet_at_vicr.com
Sent: Wednesday, January 31, 2001 1:41 AM
To: Multiple recipients of list ORACLE-L
Renee,
Is the field in Oracle defined as "NOT NULL"? This could be your problem.
Dick Goulet
Been there, done that, DOH happen again!!!
____________________Reply Separator____________________ Author: "Renee Bonnett" <renee_at_openwindows.com.au> Date: 1/29/2001 8:50 PM
I fully agree about using Access and would rather avoid it. But the only thing is I'm working on a product (not my own) that has a fully constructed frontend interface in access. Most clients of this product use Access backend except for one which uses oracle. So I'm the lucky person to converge the two.
So I'm still left with the problem below and how to overcome it somehow. I'm performing more testing to narrow down what actual records are throwing the error in respect to the field being memo in access but varchar2 in oracle. Where all of the data doesn't exceed the 2000 char limit placed in oracle.
But thankyou for your advice.
renée
-----Original Message-----
Roberts (ZADCO ITIS)
Sent: Tuesday, January 30, 2001 3:00 PM
To: Multiple recipients of list ORACLE-L
I don't like to use Microslop Access in conjunction with Oracle. One reason is that Access is running in the memory of your local PC, and therefore any problems with local memory management could cause data to be lost. This happens, Ive seen it happen, so be careful.
Sam
-----Original Message-----
Sent: Tuesday, January 30, 2001 7:15 AM
To: Multiple recipients of list ORACLE-L
Has any one else had problems appending data from one table to another
(archive) table via Access 2000 frontend through linked tables in Oracle
8.0.5 .
Where a memo column exists in Access but varchar2 (2000) in Oracle causing
it to fail.
renée
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Renee Bonnett
INET: renee_at_openwindows.com.au
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Renee Bonnett
INET: renee_at_openwindows.com.au
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: dgoulet_at_vicr.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Renee Bonnett
INET: renee_at_openwindows.com.au
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jan 30 2001 - 16:43:27 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |