My Oracle Support Banner

ORA-1400 or ORA-1407 when using the table API and filling a column with a function like USER (Doc ID 416370.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Designer - Version: 6.5 to 10.2
This problem can occur on any platform.


When inserting a row in a table that has an installed table API,
it fails with ORA-1400 or ORA-1407.


You are using the table API from Designer and just upgraded your database to


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.