Recent content by cgl

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.

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

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...

Hello, I have some object types created on Oracle 9i, defining a type hierarchy under a base supertype (see below). I also have a table that have a column of the base object type. When I insert values of the base object type and values of the child object types on the same table it works fine...