What is the Official Oracle Apex line on ITEM_NAME character lengths?
I believe some time ago, Apex started to allow ITEM_NAMEs to be more than 30 Chars.
https://docs.oracle.com/en/database/oracle/apex/23.1/htmdb/oracle-apex-limits.html
the above 23.1 documentation shows a 30 char restriction because Items longer than 30 characters cannot be referenced using bind variable syntax.
This example App shows a bind variable working on an item with the name P12345678901234567890123456789_WELL_OVER_30_CHARS
So, is the following output from the Apex Advisor correct?
Notice the Errors TRIM the Length of the ITEM to 30 Chars in the Message P12345678901234567890123456789 does not exist
Gus..
**Applications: 236648 - Test Item Name Length > Pages: 1 - Home > Regions: This proves bind variables work on Items with Names over 30 chars > Page Items > P12345678901234567890123456789_WELL_OVER_30_CHARS**AttributeItem Name (Identifies a page item and is used to maintain session state. Value may be referenced as a SQL bind variable or using APEX substitution string syntax.)CheckLength of Item or Tabular Form Column NameCategoryWarningMessageName has a length of 49 characters, but should have a maximum of 30 characters.ValueP12345678901234567890123456789_WELL_OVER_30_CHARS
**Applications: 236648 - Test Item Name Length > Pages: 1 - Home > Processes > Change_it**AttributeProcess Source (Identifies the corresponding process text for the process type)CheckReferences with Bind Variable SyntaxCategoryErrorMessageP12345678901234567890123456789 does not exist.ValueBEGIN :P12345678901234567890123456789_WELL_OVER_30_CHARS := 'I have changed this'; END;
**Applications: 236648 - Test Item Name Length > Pages: 1 - Home > Processes > ReSet_it**AttributeProcess Source (Identifies the corresponding process text for the process type)CheckReferences with Bind Variable SyntaxCategoryErrorMessageP12345678901234567890123456789 does not exist.ValueBEGIN :P12345678901234567890123456789_WELL_OVER_30_CHARS := NULL; END;