你能不能租借过程1和程序2代码在这里供我们的专家参考？


为什么不在单个程序中执行你想做的任何事情？

Could you please post the procedure 1 and procedure 2 code here for reference of our experts?

Why dont you perform what ever you want to in a single procedure itself??

感谢Amit快速回复。我没有使用单个程序来执行所有操作，因为我将数据插入到不同的表中，如果我将所有内容都包含在一个过程中，那将是一个非常大的过程。我说的问题是最初的问题。


以下是我的尝试：


第一道程序：

Thanks Amit for a quick response. I am not using a single procedure to do everything because i will be inserting data into different tables and if i include everything into one procedure it will be a very huge one. The problem i have stated is the initial one.

Following is what i am trying:

First Procedure:

为什么不简单地调用procedure1中的第二个过程并传递值。

why not simply call the 2nd procedure within procedure1 and pass the values .