errbuf,retcode放置位置导致异常
EBS环境:11.5.10
errbuf,retcode要放在最前面,要不提交请求可能会出现意外情况。
CREATE OR REPLACE PROCEDURE XXSKE_AUTO_TRX_OVERDUE_MTL
(
(
p_email IN VARCHAR2,
errbuf OUT VARCHAR2,
retcode OUT VARCHAR2
)
+---------------------------------------------------------------------------+
**Starts**01-SEP-2011 02:57:42
**Ends**01-SEP-2011 03:00:41
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---->>>Begin Send Mail----------------------------------------------------+
Mail Error
ORA-29279: SMTP permanent error: 503 Issue RCPT TO: command before DATA command
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
**Starts**01-SEP-2011 02:57:42
**Ends**01-SEP-2011 03:00:41
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---->>>Begin Send Mail----------------------------------------------------+
Mail Error
ORA-29279: SMTP permanent error: 503 Issue RCPT TO: command before DATA command
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
CREATE OR REPLACE PROCEDURE XXSKE_AUTO_TRX_OVERDUE_MTL
(
errbuf OUT VARCHAR2,
retcode OUT VARCHAR2,
p_email IN VARCHAR2
)
**Starts**01-SEP-2011 03:03:01
**Ends**01-SEP-2011 03:06:06
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---->>>Begin Send Mail----------------------------------------------------+
File IS OK
+----<<<end--------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
**Ends**01-SEP-2011 03:06:06
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---->>>Begin Send Mail----------------------------------------------------+
File IS OK
+----<<<end--------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
成长
/ | \
学习 总结 分享
QQ交流群:122230156
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步