Results 1 to 8 of 8

Thread: [RESOLVED] Stored Procedure Name Length (A simple question for Oracle users)

  1. Sep 19th, 2002, 10:46 PM #1
    abhijit
    abhijit is offline

    Thread Starter
    PowerPoster abhijit's Avatar
    Join Date
    Jun 1999
    Location
    Chit Chat Forum.
    Posts
    3,228

    Resolved [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
    Reply With Quote Reply With Quote
  2. Sep 20th, 2002, 07:27 AM #2
    Gaffer
    Gaffer is offline
    Fanatic Member Gaffer's Avatar
    Join Date
    Nov 2000
    Location
    London
    Posts
    828

    Re: Stored Procedure Name Length (A simple question for Oracle users)

    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....
    Reply With Quote Reply With Quote
  3. Oct 28th, 2002, 11:21 PM #3
    abhijit
    abhijit is offline

    Thread Starter
    PowerPoster abhijit's Avatar
    Join Date
    Jun 1999
    Location
    Chit Chat Forum.
    Posts
    3,228
    Gaffer, its actually 30 characters only in Oracle. I wonder where U got that 256 from?

    Cheers!
    Abhijit
    Reply With Quote Reply With Quote
  4. Oct 29th, 2002, 06:21 PM #4
    RSINGH
    RSINGH is offline
    Fanatic Member RSINGH's Avatar
    Join Date
    May 2001
    Location
    London
    Posts
    522
    Originally posted by abhijit
    Gaffer, its actually 30 characters only in Oracle. I wonder where U got that 256 from?

    Cheers!
    Abhijit
    So why ask?

    I have used longer and I was not happy...
    The liver is bad. It must be punished.
    Reply With Quote Reply With Quote
  6. Oct 29th, 2002, 10:49 PM #5
    abhijit
    abhijit is offline

    Thread Starter
    PowerPoster abhijit's Avatar
    Join Date
    Jun 1999
    Location
    Chit Chat Forum.
    Posts
    3,228
    I did not know it for a long time till I started reading "Beginning ORacle Programming" From Wrox.

    Cheers!
    Abhijit
    Reply With Quote Reply With Quote
  7. Oct 30th, 2002, 08:47 AM #6
    Gaffer
    Gaffer is offline
    Fanatic Member Gaffer's Avatar
    Join Date
    Nov 2000
    Location
    London
    Posts
    828
    Originally posted by abhijit
    Gaffer, its actually 30 characters only in Oracle. I wonder where U got that 256 from?

    Cheers!
    Abhijit
    err, I said "at a rough guess" it's 256 (a pretty common number used in programming)
    Reply With Quote Reply With Quote
  8. Mar 12th, 2012, 09:57 AM #7
    foluis
    foluis is offline
    New Member
    Join Date
    Mar 2012
    Posts
    1

    Re: Stored Procedure Name Length (A simple question for Oracle users)

    Is there a way to in increase stored procedure length names?
    Reply With Quote Reply With Quote
  9. Mar 16th, 2012, 12:40 PM #8
    abhijit
    abhijit is offline

    Thread Starter
    PowerPoster abhijit's Avatar
    Join Date
    Jun 1999
    Location
    Chit Chat Forum.
    Posts
    3,228

    Re: Stored Procedure Name Length (A simple question for Oracle users)

    Quote Originally Posted by foluis View Post
    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?
    Everything that has a computer in will fail. Everything in your life, from a watch to a car to, you know, a radio, to an iPhone, it will fail if it has a computer in it. They should kill the people who made those things.- 'Woz'
    save a blobFileStreamDataTable To Text Filemy blog
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width