Table HOLDING_TABLE has one column named "HOLDER". I just want to insert a five character string into the column. The string I am inserting is the word "Smile". The column colder is 300 characters wide in length. Yet when the code is executed I get the error message shown at the bottom of this post. Does anyone know why I am getting this error, when both clearStr and the target column have enough characters define?
clearStr := 'INSERT INTO HOLDING_TABLE (HOLDER) VALUES(' || ''' Smile ''' || ')';
EXECUTE IMMEDIATE clearStr;
ORA-06512 at line 01
00972. 00000 - "identifier is too long";
*Cause: An identifier with more than 30 characters was specified.
*Action: Specifiy at most 30 characters.