Home » Other » General » linking oracle tables in access
linking oracle tables in access [message #243138] Wed, 06 June 2007 04:02 Go to next message
Geiri
Messages: 3
Registered: June 2007
Location: Iceland
Junior Member

Hello
I use access to select and update data both in access databases and in a Oracle db (version 8 )
I'm having some problems update-ing a varchar2(4000) field in oracle. When the length of the text being put in the field goes over 2000 characters access/oracle truncates the string down to 2000 characters.
Here is my code:
UPDATE AL_TRYGGTEGUMSOKN SET AL_TRYGGTEGUMSOKN.MINNISP = [MINNISP] & ' text to be added'
WHERE AL_TRYGGTEGUMSOKN.ID=373896;
The data in the field MINNISP did not change because its length was allready 2000.
I'm guessing its being converted to datatype char which maximum length is 2000.
Can you help me with this problem?
Best regards, Asgeir Gudbjartsson

[Updated on: Wed, 06 June 2007 04:02]

Report message to a moderator

Re: linking oracle tables in access [message #243141 is a reply to message #243138] Wed, 06 June 2007 04:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the datatype of column MINNISP?
What is its character set?

Regards
Michel
Re: linking oracle tables in access [message #243143 is a reply to message #243141] Wed, 06 June 2007 04:11 Go to previous messageGo to next message
Geiri
Messages: 3
Registered: June 2007
Location: Iceland
Junior Member

What is the datatype of column MINNISP?
The table is in oracle and there MINNISP is of the type varchar2(4000) but when linking the table in access its type becomes Memo when viewed in access.

What is its character set?
Where can I see this property?

Thank you for answering, Geiri
Re: linking oracle tables in access [message #243145 is a reply to message #243143] Wed, 06 June 2007 04:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If it is a VARCHAR2 it is your database character set you can see in nls_database_parameters.

Regards
Michel
Re: linking oracle tables in access [message #243147 is a reply to message #243145] Wed, 06 June 2007 04:24 Go to previous message
Geiri
Messages: 3
Registered: June 2007
Location: Iceland
Junior Member

Here is the charactersets

--(Ordinary) character set
select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET';
WE8MSWIN1252

--National character set
select value from nls_database_parameters where parameter = 'NLS_NCHAR_CHARACTERSET';
AL16UTF16
Previous Topic: Oracle 10g Minimum Specification
Next Topic: SQL Plus font and background color
Goto Forum:
  


Current Time: Sat Dec 03 20:34:23 CST 2016

Total time taken to generate the page: 0.14357 seconds