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-----
[EMAIL PROTECTED]
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" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sam P. Roberts (ZADCO ITIS)
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Renee Bonnett
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Renee Bonnett
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
