{"id":2060,"date":"2016-08-10T13:37:45","date_gmt":"2016-08-10T10:37:45","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=2060"},"modified":"2016-12-12T09:22:18","modified_gmt":"2016-12-12T06:22:18","slug":"oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-01400-to-ora-01500","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-01400-to-ora-01500\/","title":{"rendered":"Oracle 12c R2 Error Codes and Solution Suggestions from ORA-01400 to ORA-01500"},"content":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-01400 to ORA-01500<\/strong><\/p>\n

\n
ORA-01400: cannot insert NULL into (string)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to insert NULL into previously listed objects.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0These objects cannot accept NULL values.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01401: inserted value too large for column<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The value inserted was too large for the given column.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not insert a value greater than what the column can hold.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01402: view WITH CHECK OPTION where-clause violation<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01403: no data found<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0No data was found from the objects.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0There was no data from the objects which may be due to end of fetch.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01404: ALTER COLUMN will make an index too large<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01405: fetched column value is NULL<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01406: fetched column value was truncated<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The fetched column values were truncated.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use the right data types to avoid truncation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01407: cannot update (string<\/i>) to NULL<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01408: such column list already indexed<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01409: NOSORT option may not be used; rows are not in ascending order<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Creation of index with NOSORT option when rows were not ascending. For non-unique indexes the rowid is considered part of the index key. Therefore, if you create an index nosort and two of the rows in the table have the same key and are stored in ascending order, but get split accross two extents where the dba of the first block in the second extent is less than the dba of the last block in the first extent, then the create index nosort may fail.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create the index without the NOSORT option, or ensure table is stored in one extent.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01410: invalid ROWID<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01411: cannot store the length of column in the indicator<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Tried to fetch a column of size more than 64K and couldn’t store the length of the column in the given indicator of size 2 bytes.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use the new bind type with call backs to fetch the long column.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01412: zero length not allowed for this datatype<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The length for type 97 is 0<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the correct length.<\/span><\/span>
\n<\/p>\n

\n
<\/a> ORA-01413: illegal value in packed decimal number buffer<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user buffer bound by the user as packed decimal number contained an illegal value.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a legal value.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01414: invalid array length when trying to bind array<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to bind an array without either a current array length pointer or a zero maximum array length.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Sepcify a valid length.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01415: too many distinct aggregate functions<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The query contains more distinct aggregates than can be processed. The current limit is 255.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reduce the number of distinct aggregate functions in the query.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01416: two tables cannot be outer-joined to each other<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01417: a table may be outer joined to at most one other table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0a.b (+) = b.b and a.c (+) = c.c is not allowed<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check that this is really what you want, then join b and c first in a view.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01418: specified index does not exist<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01419: datdts: illegal format code<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01420: datstd: illegal format code<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01421: datrnd\/dattrn: illegal precision specifier<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01422: exact fetch returns more than requested number of rows<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The number specified in exact fetch is less than the rows returned.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rewrite the query or change number of rows requested<\/span><\/span><\/p>\n

\n
<\/a> ORA-01423: error encountered while checking for extra rows in exact fetch<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01424: missing or illegal character following the escape character<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The character following the escape character in LIKE pattern is missing or not one of the escape character, ‘%’, or ‘_’.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the escape character or specify the missing character.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01425: escape character must be character string of length 1<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Given escape character for LIKE is not a character string of length 1.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change it to a character string of length 1.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01426: numeric overflow<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Evaluation of an value expression causes an overflow\/underflow.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reduce the operands.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01427: single-row subquery returns more than one row<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01428: argument ‘string<\/i>‘ is out of range<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01429: Index-Organized Table: no data segment to store overflow row-pieces<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0No overflow segment defined.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Add overflow segment.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01430: column being added already exists in table<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01431: internal inconsistency in GRANT command<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01432: public synonym to be dropped does not exist<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01433: synonym to be created is already defined<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01434: private synonym to be dropped does not exist<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01435: user does not exist<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01436: CONNECT BY loop in user data<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01437: cannot have join with CONNECT BY<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01438: value larger than specified precision allowed for this column<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0When inserting or updating records, a numeric value was entered that exceeded the precision defined for the column.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Enter a value that complies with the numeric column’s precision, or use the MODIFY option with the ALTER TABLE command to expand the precision.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01439: column to be modified must be empty to change datatype<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01440: column to be modified must be empty to decrease precision or scale<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01441: cannot decrease column length because some value is too big<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01442: column to be modified to NOT NULL is already NOT NULL<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01443: internal inconsistency; illegal datatype in resultant view column<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01444: internal inconsistency; internal datatype maps to invalid external type<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc.<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01447: ALTER TABLE does not operate on clustered columns<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01448: index must be dropped before changing to desired type<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01449: column contains NULL values; cannot alter to NOT NULL<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01450: maximum key length (string<\/i>) exceeded<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01451: column to be modified to NULL cannot be modified to NULL<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0the column may already allow NULL values, the NOT NULL constraint is part of a primary key or check constraint.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0if a primary key or check constraint is enforcing the NOT NULL constraint, then drop that constraint.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01453: SET TRANSACTION must be first statement of transaction<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0self-evident<\/span><\/span><\/p>\n

Action:<\/b>\u00a0commit (or rollback) transaction, and re-execute<\/span><\/span><\/p>\n

\n
<\/a> ORA-01454: cannot convert column into numeric datatype<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01455: converting column overflows integer datatype<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01456: may not perform insert\/delete\/update operation inside a READ ONLY transaction<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A non-DDL insert\/delete\/update or select for update operation was attempted<\/span><\/span><\/p>\n

Action:<\/b>\u00a0commit (or rollback) transaction, and re-execute<\/span><\/span><\/p>\n

\n
<\/a> ORA-01457: converting column overflows decimal datatype<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01458: invalid length inside variable character string<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01459: invalid length for variable character string<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01460: unimplemented or unreasonable conversion requested<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01461: can bind a LONG value only for insert into a LONG column<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01462: cannot insert string literals longer than 4000 characters<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01463: cannot modify column datatype with current constraint(s)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to modify the datatype of column which has referential constraints; or has check constraints which only allows changing the datatype from CHAR to VARCHAR or vise versa.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the constraint(s) or do not perform the offending operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01464: circular grant (granting to grant ancestor) of table or view<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01465: invalid hex number<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01466: unable to read data – table definition has changed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Query parsed after tbl (or index) change, and executed w\/old snapshot<\/span><\/span><\/p>\n

Action:<\/b>\u00a0commit (or rollback) transaction, and re-execute<\/span><\/span><\/p>\n

\n
<\/a> ORA-01467: sort key too long<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01468: a predicate may reference only one outer-joined table<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01469: PRIOR can only be followed by a column name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempting to specify “PRIOR\u00a0something<\/i>” where\u00a0something<\/i>\u00a0is not a column name.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Only a column name can follow PRIOR. Replace with a column name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01470: In-list iteration does not support mixed operators<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Constants of different types are specified in an in-list.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use constants of same type for in-lists.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01471: cannot create a synonym with same name as object<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01472: cannot use CONNECT BY on view with DISTINCT, GROUP BY, etc.<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01473: cannot have subqueries in CONNECT BY clause<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01474: cannot have START WITH or PRIOR without CONNECT BY<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01475: must reparse cursor to change bind variable datatype<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01476: divisor is equal to zero<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01477: user data area descriptor is too large<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01478: array bind may not include any LONG columns<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User is performing an array bind with a bind variable whose maximum size is greater than 2000 bytes.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Such bind variables cannot participate in array binds. Use an ordinary bind operation instead.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01479: last character in the buffer is not Null<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A bind variable of type 97 does not contain null at the last position<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make the last character null<\/span><\/span><\/p>\n

\n
<\/a> ORA-01480: trailing null missing from STR bind value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A bind variable of type 5 (null-terminated string) does not contain the terminating null in its buffer.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Terminate the string with a null character<\/span><\/span><\/p>\n

\n
<\/a> ORA-01481: invalid number format model<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user is attempting to either convert a number to a string via TO_CHAR or a string to a number via TO_NUMBER and has supplied an invalid number format model parameter.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Consult your manual.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01482: unsupported character set<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The character set used to perform the operation, such as the CONVERT function, is not a supported character set.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use one of the supported character sets.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01483: invalid length for DATE or NUMBER bind variable<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A bind variable of type DATE or NUMBER is too long.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Consult your manual for the maximum allowable length.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01484: arrays can only be bound to PL\/SQL statements<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0You tried to bind an array to a non-PL\/SQL statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-01485: compile bind length different from execute bind length<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0You bound a buffer of type DTYVCS (VARCHAR with the two byte length in front) and at execute time the length in the first two bytes is more than the maximum buffer length (given in the bind call). The number of elements in the array and the current number of elements in the array cannot be more than the maximum size of the array.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-01486: size of array element is too large<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0You tried to bind a data value which was either too large for the datatype (for example, NUMBER) or was greater than 4000 bytes (for example, VARCHAR or LONG).<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-01487: packed decimal number too large for supplied buffer<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An impossible request for decimal to oracle number conversion was made<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This conversion cannot be performed<\/span><\/span><\/p>\n

\n
<\/a> ORA-01488: invalid nibble or byte in the input data<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An impossible request for decimal to oracle number conversion was made<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This conversion cannot be performed<\/span><\/span><\/p>\n

\n
<\/a> ORA-01489: result of string concatenation is too long<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0String concatenation result is more than the maximum size.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make sure that the result is less than the maximum size.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01490: invalid ANALYZE command<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Incorrect syntax specified<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Retry the command<\/span><\/span><\/p>\n

\n
<\/a> ORA-01491: CASCADE option not valid<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The CASCADE option is only valid for tables or clusters.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not specify CASCADE<\/span><\/span><\/p>\n

\n
<\/a> ORA-01492: LIST option not valid<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The LIST option is only valid for tables or clusters.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not specify LIST<\/span><\/span><\/p>\n

\n
<\/a> ORA-01493: invalid SAMPLE size specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified SAMPLE size is out of range<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a value within the proper range.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01494: invalid SIZE specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified histogram SIZE value was out of range.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a value within the proper range.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01495: specified chain row table not found<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified table either does not exist or user does not have the proper privleges.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the correct table to use.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01496: specified chain row table form incorrect<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified table does not have the proper field definitions.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the correct table to use.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01497: illegal option for ANALYZE CLUSTER<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The FOR COLUMNS\u00a0column-list<\/i>\u00a0clause may not be used with ANALYZE CLUSTER.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Retry with a legal syntax.<\/span><\/span><\/p>\n

\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-01400 to ORA-01500 ORA-01400: cannot insert NULL into (string) Cause:\u00a0An attempt was made to insert NULL into previously listed objects. Action:\u00a0These objects cannot accept NULL values. ORA-01401: inserted value too large for column Cause:\u00a0The value inserted was too large for the given column. Action:\u00a0Do not insert…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[54],"class_list":["post-2060","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-xe","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2060","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=2060"}],"version-history":[{"count":2,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2060\/revisions"}],"predecessor-version":[{"id":2105,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2060\/revisions\/2105"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2060"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2060"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2060"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}