-
reference cursor from a procedure & pass cursor as a paramater
How to call/reference a cursor defined in a procedure A from another procedure B? How to pass a cursor as a parameter of a cursor?
-
reference table from inside a procedure
How do you reference a (updated) table from procedure A which is being updated by another procedure B?
-
What happens to the base table transactions when procedure has some error?
Procedure A calls procedure B. A updates table t1, t2. B updates table t3. If some error happens to B what happens to the updates in all those tables? Whether they will rollback or commit? If commits how far it will commit?