LSX-00162: string "~S" is an invalid default for the complex
type



LSX-00162: string "~S" is an invalid default for the complex type..

Answer / guest

Cause: If the {content type} is a simple type definition,
then the string must be valid with regard to the simple type
definition as defined by String Valid (3.14.4). If the
{content type} is mixed, then the {content type}'s particle
must be emptiable as defined by Particle Emptiable (3.9.6).
However, one of these conditions was not met, resulting in
this error.

Action: Make the default string a valid default with regard
to the complex type definition.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-600?

1 Answers   IBM,


ORA-14408: partitioned index contains subpartitions in a different tablespace

1 Answers  


LSX-00211: value "~1S" whose fractional digits exceeds ~2d

1 Answers  


RMAN-08589: channel string: starting datafile conversion

1 Answers  


ORA-13787: missing SQL profile for statement object "string" for tuning task "string"

1 Answers  






ORA-30550: index depends on a package/function spec/body which is not valid

1 Answers  


QSM-00768: the search condition is invalid for the requested operation

1 Answers  


IMG-00003: exhausted memory while processing image

1 Answers  


ORA-02157: no options specified for ALTER USER

1 Answers  


QSM-02135: agg(expr) requires correspondng AVG(expr) function

1 Answers  


PCB-00630: Host variable is not of LOB type

1 Answers  


IMG-00511: %s

1 Answers  


Categories