Oracle 9i INTERVAL datatype

[cgl]

Hello,

I'm working with DOA 3.4.6.4, in Delphi 7, and Oracle 9i (9.2.0.1.0) Database.

My application have to edit a table like the following :

CREATE TABLE SERVICE_LEVEL (
LEVEL NUMBER,
DESCRIPTION VARCHAR2(50),
DURATION INTERVAL DAY(2) TO SECOND(0));

When I insert a new record, everything works just fine, but when I try to edit any filed of a record from this table, I get the following error message :

ORA-01406 fetched column value was truncated

I've tried to use TO_CHAR(DURATION) on the SQL statement, but I still have the same problem.

Does DOA have any support to INTERVAL fields at all? Or just to TIMESTAMP?

Anyone can help?

Thanks, Cezar

 

[cgl]

I just remeber that when I use PL/SQL Developer 5.1.2.682 to "Edit data" from this table, I have no problems!!

PL/SQL Developer works with ITERVAL fields, but DOA doesn't.

I hope this helps you to find any solution or workaround to this.

Thanks, Cezar

 

[Marco Kalter]

Interval will be supported in the upcoming 4.0 release. Right now you need to use the to_char function to convert it to a character string in your query.

------------------
Marco Kalter
Allround Automations

 

[cgl]

Originally posted by mkalter:
Interval will be supported in the upcoming 4.0 release. Right now you need to use the to_char function to convert it to a character string in your query.

Like I said on my first post, I've tried to use the to_char function to convert it to a character string but I still get the same error message. I just wonder how PL/SQL developer handles it, since it has no problem dealing with INTERVAL fields.