Interval in COMMAND WINDOW

[Christo Kutrovsky]

The interval datatype is not handled properly in the command window.

QL> create table test (a interval day to second);

Table created

SQL> insert into a values(numtodsinterval(1, 'hour'));

insert into a values(numtodsinterval(1, 'hour'))

ORA-00942: table or view does not exist

SQL> insert into test values(numtodsinterval(1, 'hour'));

1 row inserted

SQL> select * from test;

A
-------------------------------------------------------------------------------

SQL>

However, running from the SQL window, the value is shown.

 

[Marco Kalter]

This is fixed in the upcoming 5.1.4 release, which will be available shortly.

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

 

[Christo Kutrovsky]

Excellent.

How about the "ORA-01460 unimplemented or unreasonable conversion requested"

error I am getting randomly (5.1.3.704). Sometimes when I compile, sometimes when I browse objects. It seems that sometimes when using bind variables this happens.

Have you done some changes in regard to this problem? (it's very annoying as I have to close pl/sql to eventually get arround it).