When declaring the name of a procedure in sqldevelope
I get this message
Erro: ORA-00972: identifier is too long
Naming example:
PRC_IMVW_TISS_VERIFICA_ELEGIBILIDADE
CREATE OR REPLACE PROCEDURE PRC_IMVW_TISS_VERIFICA_ELEGIBILIDADE AS
BEGIN
DBMS_OUTPUT.PUT_LINE('Hello World!');
END PRC_IMVW_TISS_VERIFICA_ELEGIBILIDADE;
When you encounter an ORA-00972 error, the following error message will appear:
ORA-00972: identifier is too long.
Translation:
ORA-00972: The handle is too long
Finding reference to this error:
Cause: The name of a schema object exceeds 30 characters. Schema objects are tables, clusters, views, indexes, synonyms, tablespaces, and usernames.
Translation
You tried to reference a table, cluster, view, index, synonym, tablespace, or username with a value greater than 30 characters.
Solution:
Action: Shorten the name to 30 characters or less.
Translation
Names for tables, clusters, views, indexes, synonyms, table spaces and user names must be 30 characters or any less. You must shorten the name to no more than 30 characters to these objects.
The name of your procedure has 36 characters, remove 6 characters that the error will no longer occur.
Source: link