Results 1 to 6 of 6

Thread: Procedure

  1. #1
    Junior Member
    Join Date
    Oct 2007
    Answers
    12

    Procedure

    Is there any parameter limit defined for a procedure(IN+OUT+ IN OUT)??
    how many at max we can define??


  2. #2
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Procedure

    There can be any number of paramters for a procedure in oracle but in SQL Server 2000 the number is 2100 .


  3. #3
    Junior Member
    Join Date
    Oct 2007
    Answers
    12

    Re: Procedure

    Thanks for the reply but i think there is a limit upto 254. I am not sure about the count but limit is definately ther.


  4. #4
    Junior Member
    Join Date
    Nov 2006
    Answers
    9

    Re: Procedure

    Quote Originally Posted by Sant_parkash View Post
    Is there any parameter limit defined for a procedure(IN+OUT+ IN OUT)??
    how many at max we can define??
    No, there is no limit for declaring the parameter in procedures.


  5. #5
    Junior Member
    Join Date
    Nov 2006
    Answers
    9

    Re: Procedure

    no, that restriction is only upto Ora8i


  6. #6
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Thumbs up Re: Procedure

    Quote Originally Posted by Sant_parkash View Post
    Thanks for the reply but i think there is a limit upto 254. I am not sure about the count but limit is definately ther.
    As i have told you, there is no limit on the number of parameters for a procedure in oracle.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact