Forum Stats

  • 3,874,978 Users
  • 2,266,788 Discussions
  • 7,912,039 Comments

Discussions

Reg: Limit on calling no of procedures inside a proc

EV259
EV259 Member Posts: 200
edited Jan 14, 2014 12:42AM in SQL & PL/SQL

Dear All,

I am sure it is bit silly question, but wanted to clarify. Do we have any limit on calling the no of procedures inside a procedure.

Thanks.

Tagged:

Answers

  • JustinCave
    JustinCave Member Posts: 30,293 Gold Crown

    It depends on exactly what you are asking...

    In general, you can call as many procedures as you'd like.  There are limits on the size of objects like procedures so, in theory, there is a point where a procedure would get so large that you'd have to break it up.  Of course, good programming practice would be to break the procedure up long, long before that point if only to keep it readable.  There are also potentially limits on things like recursion depth which might be something you're asking about.

    Justin

  • David Berger
    David Berger Member Posts: 345 Silver Badge

    Hello EV259

    I think if you make such a question then you are on a wrong way...

    But.. hier is a good summary of the PL/SQL Limitations: PL/SQL Program Limits

    Maybe this helps you.

  • EV259
    EV259 Member Posts: 200
    In general, you can call as many procedures as you'd like.
    

    Thanks Mr Justin and Mr David for your replies.

    Thanks

This discussion has been closed.