Home > database >  The oracle stored procedure call
The oracle stored procedure call

Time:09-27

A and B have two storage process, the content is not the same as the name, call A stored procedure for testing and debugging A no problem, when the parameters of the same call A stored procedure B, step by step in the process of storage, display content of the stored procedure C, I really doubt life ah, the great god who can show you why? Stored procedure call, but not in the first row, a few hundred lines below

CodePudding user response:

It's not likely ah,,,

CodePudding user response:

Rule out the choice of different input parameters leads to different, there is a branch conditions associated with time? Or, more likely, the process may be changed some objects of data, and the logic process, have some table data, the data may affect the choice of the branch such as: how many? Some branch call C process, and some have no?

CodePudding user response:

Stored procedure A, B, C code can you provide? So analysis the question!

CodePudding user response:

Is to use the PLSQL developer?
Before call step by step, to add debugging information, select the stored procedure right, add the debug information

CodePudding user response:

I began to doubt the life, not to say that there are only two stored procedures A and B?
Stored procedure C come from?

CodePudding user response:

Stick the A, B, C code first
  • Related