"ORA-00972: identifier is too long" inserting Oracle BLOB using Node.js

Question

i have base64 string (pdf) and want to insert that into oracle blob in node js. Tried with Creating a buffer from the base64 string and encoded the buffer as a utf8 string, but received below error. Please let me know the solution.

Error: ORA-00972: identifier is too long

Please show us your code. Why do you try to encode pure ASCII into UTF-8? It is useless. — Wernfried Domscheit
– Wernfried Domscheit, Commented Mar 24, 2021 at 8:42

Antier Solutions · Accepted Answer · 2021-03-24 10:42:11Z

1

No, prior to Oracle version 12.2, identifiers are not allowed to exceed 30 characters in length. See the Oracle SQL Language Reference.

ORA-00972 identifier is too long alias column name

answered Mar 24, 2021 at 10:42

Antier Solutions

1,4229 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

"ORA-00972: identifier is too long" inserting Oracle BLOB using Node.js

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related