1
When declaring the name of a trial in sqldevelope
get that message
Erro: ORA-00972: identifier is too long
Example of nomenclature:
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;
1
When you encounter an ORA-00972 error, the following error message will appear:
ORA-00972: Dentifier is Too long.
Translation:
ORA-00972: the identifier is very long
Looking I found the reference about 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, display, 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 have 30 characters or less. You must shorten the name to no more than 30 characters to these objects.
The name of his Procedure has 36 characters, remove 6 characters that the error will no longer occur.
Source: http://www.dba-oracle.com/sf_ora_00972_identifier_is_too_long.htm
Browser other questions tagged sql oracle procedure
You are not signed in. Login or sign up in order to post.