Menu
Possible Duplicate:
Why are Oracle table/column/index names limited to 30 characters?
When writing a stored procedure in Oracle, I chose a particularly descriptive name, and when attempting to update the script I was informed the name was too long.
37 15 PLS-00114: identifier 'blah_blah_blah_blah_blah_blah' too long
Why is there such a restrictive limit on stored proc names? Is this just specific to Oracle or is this common in other db systems?
Sorry for the duplicate
547
Maximum length for stored procedures and functions name is 128. Always choose name as meaningful and as much as short.
You should never write such a monstrosity.... any function/procedure should be no more than two pages long - and that's taking a very liberal stand on this matter....
SQL maximum column name length limitation is 128 characters. If we create more than 128 characters, it shows an error.
its actually 30 characters only in Oracle.
Every language/db has limit of length while defining names because the name of every object created in DB is stored in system tables and every column has some fixed length.
For performance, we keep the names short in case of DB.
144
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
