Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can two functions call each other?

oatsAug 9 2009 — edited Aug 10 2009
I'm converting some code and have run into two functions that call each other. While I seem to have converted both functions to plsql ok, they do not compile, seemingly because they ref each other. As soon as I de-reference one one function's call to the other function they both compile.

I know that Oracle 10g supports recursion; and on the surface of things, this situation does not seem much different than recursion. If both functions are well formed, I would hope that they'd compile.

I wasn't able to find much by searching the forums on this topic...but I'm hoping that someone will have some info on this issue.
This post has been answered by Frank Kulash on Aug 10 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 7 2009
Added on Aug 9 2009
16 comments
1,839 views