[RESOLVED] Stored Procedure Name Length (A simple question for Oracle users)
Hi there,
I have a simple and basic question about the Oracle Database.
What is the maximum length that Oracle allows you to maintain for the name of a stored procedure?
If you have people out there who are using TOAD? Does TOAD impose a limit on the length of the name?
Please answer this question.
Thanks & Regards,
Abhijit
Re: Stored Procedure Name Length (A simple question for Oracle users)
Quote:
Originally posted by abhijit
Hi there,
I have a simple and basic question about the Oracle Database.
What is the maximum length that Oracle allows you to maintain for the name of a stored procedure?
If you have people out there who are using TOAD? Does TOAD impose a limit on the length of the name?
Please answer this question.
Thanks & Regards,
Abhijit
I use TOAD - but I bet the method I use to test how long a procedure name can be is the sam method as you would test it.... i.e. why not try it yourself?
At a rough guess, I'd say 256 would be your maximum - mind you, if I was a programmer abuot to take on a project that has procedures with names > 100 letters, I wouldn't be overly happy....
Re: Stored Procedure Name Length (A simple question for Oracle users)
Is there a way to in increase stored procedure length names?
Re: Stored Procedure Name Length (A simple question for Oracle users)
Quote:
Originally Posted by
foluis
Is there a way to in increase stored procedure length names?
No. There is no way. This limit is imposed by the database. You cannot increase the stored procedure length.
SIDENOTE:
Wow, how did you get this thread resurrected?