OTL翻译(7) -- otl_exception类

最新推荐文章于 2021-02-07 00:19:59 发布
转载 最新推荐文章于 2021-02-07 00:19:59 发布 · 1.6k 阅读 · 0

本文介绍了OTL中用于抛出异常的otl_exception类。详细解释了类中的成员变量及其用途，包括SQL语句信息、变量信息、错误信息、错误码等，并提供了针对不同数据库API的说明。

原文地址:http://blog.sina.com.cn/s/blog_79d599dc0100rnxy.html

 

 

otl_exception

这个类是OTL用来抛出异常的类。如果数据库API返回一个非0的错误值，则OTL会将会抛出一个otl_exception的异常。一个otl_exception异常有可能是一个数据库错误或是一个OTL定义的错误。

序号

函数、成员变量

说明

1

char stm_text[2048 or OTL_EXCEPTION_STM_TEXT_SIZE]

OTL异常里面SQL语句的前2047个字符。当设置了stream label（在otl_stream或open()函数里面的sqlstm_label设置）后，它就被SQL的数据成员替代了SQL语句。

2

char var_info[256]

如果抛出了“Incompatible data types in stream operation”异常，则该变量被用来填充绑定变量和字段信息。如：bind variable name/select output column number <datatype>

3

#if defined(OTL_UNICODE_EXCEPTION_AND_RLOGON)

SQLWCHAR msg[1000];

#else

unsigned char msg[1000];

#endif

数据库错误信息或是OTL错误信息。

4

int code

数据库错误的编码或是OTL错误编码

5

#if defined(OTL_UNICODE_EXCEPTION_AND_RLOGON)

SQLWCHAR sqlstate[1000];

#else

unsigned char sqlstate[1000];

#endif

仅适用于ODBC或DB2 CLI。对于OCI它始终为空。

用来存放SQL的状态信息，详细请见ODBC或DB2 CLI手册。

6

#if defined(OTL_EXTENED_EXCEPTION)

#if defined(OTL_UNICODE_EXCEPTION_AND_RLOGON)

int arr_len;

SQLWCHAR *msg_arr[];

SQLWCHAR *sqlstate_arr[];

int code_arr[]

#else

int arr_len;

char * msg_arr[];

char * sqlstate_arr[];

int code_arr[];

#endif

#endif

扩展字段信息。通过SQLGetDiagRec()函数，获取所有的ODBC/DB2 CLI动态记录信息。

OTL的异常往往只取第一条信息，但对于ODBC、DB2 CLI在某些情况下，它会带有多条动态的信息，此时该变量里面包含有所有的信息。arr_len是信息数量。

msg_arr里面是消息；sqlstate_arr里面是sqlstate；code_arr里面是错误码。

7

#if defined(OTL_EXCEPTION_ENABLE_ERROR_OFFSET)

int error_offset

#endif

仅适用于OCI。

SQL语句解析错误码。

8

enum{disabled = 0,enabled = 1};

定义两个常量用于静态的SQL语句。

OTL学习笔记--OTLHelper的实现
静影沉璧
04-24 6695
OTL简介OTL是Oracle, ODBC and DB2-CLI Template Library的缩写，目前版本是4.0，是基于C++模板机制的C++库。 OTL 4.0 由一个C++模板框架(C++ template framework)和许多OTL适配器(OTL-adapters)组成。框架是OTL streams的泛型实现，OTL适配器是底层数据库API的包装类，作为对象的类型参
C++程序中使用OTL来操作Oracle数据库
qq_20853741的博客
12-01 1571
关于OTL，网上介绍的也不少，但看来看去也只是官方的那些文档。OTL很好用，结合官方提供的一些例子，多多尝试才能领悟。经过一个月左右的项目开发，对OTL也有些了解，在这里总结一下，希望对刚接触OTL的新手有所帮助。其中有些地方，比如对网络异常的处理，可是费了我两天的时间才解决的，我那个汗哪。废话少说，开始正题：一、开始前的准备工作 在使用OTL进行编程之前，要首先确定使用的Oralce版本以及所选用的字符集。OTL支持目前几乎所有的主流数据库，可以通过宏启用otlv4.h中对应的数据库操作接口。 如：使用O
OTL 4.0,otl_exception类
kanwoerzi
10-09 248
otl_exception 这个类是OTL用来抛出异常的类。如果数据库API返回一个非0的错误值，则OTL会将会抛出一个otl_exception的异常。一个otl_exception异常有可能是一个数据库错误或是一个OTL定义的错误。 序号 函数、成员变量 说明 1 char stm_text[2048 or OTL_EXCEPTION_S...
OTL翻译(8) -- otl_exception类
晴天的专栏
10-15 2233
otl_exception 这个类是OTL用来抛出异常的类。如果数据库API返回一个非0的错误值，则OTL会将会抛出一个otl_exception的异常。一个otl_exception异常有可能是一个数据库错误或是一个OTL定义的错误。 序号 函数、成员变量 说明 1 char stm_text[2048 or OTL_EXCEP
OTL常见报错
luobotoutou123的博客
04-14 1108
1.otl_sql_handle.get_rpc()： 含义：已经取出或插入几次参数。注意：delete时，一直为0。 2.字段设置的大小要一致。 如：user_id varchar2[5] ,则操作时,user_id<char[6]>，而输入的sUserId[6]大小为6. 即otl_stream_handle<<sUserId; OTL异常一般是OR...
linux otlv4 mysql_OTL 知识点及执行异常错误处理
weixin_42509597的博客
02-07 447
1.otl_sql_handle.get_rpc()：含义：已经取出或插入几次参数。注意：delete时，一直为0。2.字段设置的大小要一致。如：user_id varchar2[5] ,则操作时,user_id，而输入的sUserId[6]大小为6. 即otl_stream_handle<OTL异常一般是ORACLE错误：特殊：当卡死的时候，一般是设置的缓存大小不够。OTL库执行异常[32...
OTL技术应用
11-08 359
什么是OTL:OTL 是 Oracle, Odbc and DB2-CLI TemplateLibrary 的缩写，是一个操控关系数据库的C++模板库，它目前几乎支持所有的当前各种主流数据库，如下表所示： 数据库 访问接口 支持版本 Oracle OCI OCI7、OCI8、O...
OTL实战小结源码
12-13
7. **异常处理**：OTL使用C++异常处理机制来捕获数据库操作可能出现的错误。例如，`try { ... database operation ... } catch (otl_exception p) { cerr << p.err_msg() ; cerr () ; cerr << p.ora_sqlerrnum() ; }...
otl数据库.pdf
09-27
`otl_exception`类用于捕获和处理与数据库交互时出现的异常。它包含了错误信息，可以用来调试和日志记录。 ### OTL库数据库操作 OTL库支持执行SQL语句，并可以进行插入（INSERT）、删除（DELETE）、更新（UPDATE）...
改之前：/* * システム名 ：受発注システム * 機能概要：オンラインテストで扱う商品は、検討商品マスタから作成 * * 引数１ バッチID * 引数２ 業務日付 * */ \set ON_ERROR_STOP on \pset columns 32767 /* ログ出力 */ CREATE OR REPLACE PROCEDURE OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(LEVEL IN CHAR, C_FUNC_ID IN CHAR, P_BATCH_ID IN VARCHAR, MESSAGE IN VARCHAR) AS $$ BEGIN PERFORM DBMS_OUTPUT.SERVEROUTPUT(TRUE); PERFORM DBMS_OUTPUT.PUT_LINE(CLOCK_TIMESTAMP() ||' '|| COALESCE(LEVEL, '') ||' '|| C_FUNC_ID ||' '|| P_BATCH_ID ||' '|| COALESCE(MESSAGE, '') ); END $$ LANGUAGE plpgsql; DO $$ DECLARE C_LOG_LEVEL_INFO CONSTANT char(4) := 'INFO'; C_LOG_LEVEL_ERROR CONSTANT char(5) := 'ERROR'; C_FUNC_ID CONSTANT char(3) := 'OTL'; C_JOB_TITLE CONSTANT varchar(256) := '検討商品マスタ取込'; P_BATCH_ID varchar(256) := current_setting('custom.batch_id'); -- バッチID P_GYOMU_DATE varchar(8) := current_setting('custom.gyomu_date'); -- 業務日付 /* 変数 */ V_PROC_CNT_CMT numeric := 0; -- 処理件数 exitCd INTEGER = 0; BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '検討商品マスタ取込 登録開始'); -- 地区便_切捨 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区便情報　削除開始'); TRUNCATE TABLE BX_M_080_TYUKO_SHO_CHIKUB_JOHO; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区便情報　削除終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区便情報　削除エラー'); RAISE; END; -- 地区便_登録 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区便情報　登録開始'); INSERT INTO BX_M_080_TYUKO_SHO_CHIKUB_JOHO ( shuhnno, hcchukbn, chkcd, shuhncd, bnkbn, applystrtb, applyendb, shrkbn, turkjshrmode, tkbishuhnkbn, tkbioyfmcd, brshuhncd, hcchustrtb, hcchustpstrtb, hcchustpendb, trkshb, trkshkbn, shuhntrkshrasnkbn, hcchushrtnikbn, mnmmhcchubsu, mxmmhcchubsu, plucd, plucdhnkuumkbn, poskbn, knrnnshuhncd, tnphishnsmflg, turkntj, turkshid, turkprgrmid, updtntj, updtshid, updtprgrmid, updtkisu ) SELECT shuhnno, hcchukbn, chkcd, shuhncd, bnkbn, applystrtb, applyendb, shrkbn, turkjshrmode, tkbishuhnkbn, tkbioyfmcd, brshuhncd, hcchustrtb, hcchustpstrtb, hcchustpendb, trkshb, trkshkbn, shuhntrkshrasnkbn, hcchushrtnikbn, mnmmhcchubsu, mxmmhcchubsu, plucd, plucdhnkuumkbn, poskbn, knrnnshuhncd, tnphishnsmflg, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, 0 FROM BX_M_050_KSHO_CHIKU_BIN_JOHO WHERE shrkbn IN ('01', '02') AND applystrtb <= P_GYOMU_DATE AND applyendb >= P_GYOMU_DATE; GET DIAGNOSTICS V_PROC_CNT_CMT = ROW_COUNT; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区便情報 登録件数: ' || V_PROC_CNT_CMT || '件'); CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区便情報　登録終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区便情報　登録エラー'); RAISE; END; -- 地区_切捨 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区情報　削除開始'); TRUNCATE TABLE BX_M_081_TYUKO_SHO_CHIKU_JOHO; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区情報　削除終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区情報　削除エラー'); RAISE; END; -- 地区_登録 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区情報　登録開始'); INSERT INTO BX_M_081_TYUKO_SHO_CHIKU_JOHO ( shuhnno, hcchukbn, chkcd, applystrtb, applyendb, shrkbn, turkjshrmode, cmumkbn, cminfrmtn, grpkbn, shuhnstsmi1, shuhnstsmi2, shuhnstsmi3, shuhnstsmi4, shuhnstsmi5, shuhnstsmi6, dsgnpckghnkuarflg, shuhnstsmipckghnkuyu, irs, caseirs, setirs, brshuhncd, setbrkbn, zikshbninfrmtnkbn, hnpnkknstrtb, hnpnkknendb, shuhncmmnt, bik, nrrts, tsjgnk, gnkhkkkn, gnkhkkkngnk, shryutrhkskcd, mkrcd, brndcd, linkyukukbn, shuhnturkyudepotcd, hssipttrn, sshkehhkbn, sshkeshuhncd, sshkeshuhnnmknj, shuhnhnkurasnkbn, kntgiturkb, shuhnrank, hyjnfaceumkbn, nwshuhnflg, newkbn, nryrkbn, inptkbn, bikhnkukbn, shkiturkb, hssshuhnflg, dphngzuhishnflg, shuhnsts, shmkgn, hnbikgn, nuhnkgn, sitiziksu, mrktngnewshkkub, mrktngnewsgsu, mrktngnewsksikbn, mrktngnewshknb, dichuhyjkbn, hcchustpkbn, hnnmssg, ffhnbikgntm, ffhnbikgntshgiflg, untgrupcd, shrkktishid, shrshunnshid, shunnjkykbn, tnphishnsmflg, turkntj, turkshid, turkprgrmid, updtntj, updtshid, updtprgrmid, updtkisu ) SELECT shuhnno, hcchukbn, chkcd, applystrtb, applyendb, shrkbn, turkjshrmode, cmumkbn, cminfrmtn, grpkbn, shuhnstsmi1, shuhnstsmi2, shuhnstsmi3, shuhnstsmi4, shuhnstsmi5, shuhnstsmi6, dsgnpckghnkuarflg, shuhnstsmipckghnkuyu, irs, caseirs, setirs, brshuhncd, setbrkbn, zikshbninfrmtnkbn, hnpnkknstrtb, hnpnkknendb, shuhncmmnt, bik, nrrts, tsjgnk, gnkhkkkn, gnkhkkkngnk, shryutrhkskcd, mkrcd, brndcd, linkyukukbn, shuhnturkyudepotcd, hssipttrn, sshkehhkbn, sshkeshuhncd, sshkeshuhnnmknj, shuhnhnkurasnkbn, kntgiturkb, shuhnrank, hyjnfaceumkbn, nwshuhnflg, newkbn, nryrkbn, inptkbn, bikhnkukbn, shkiturkb, hssshuhnflg, dphngzuhishnflg, shuhnsts, shmkgn, hnbikgn, nuhnkgn, sitiziksu, mrktngnewshkkub, mrktngnewsgsu, mrktngnewsksikbn, mrktngnewshknb, dichuhyjkbn, hcchustpkbn, hnnmssg, ffhnbikgntm, ffhnbikgntshgiflg, untgrupcd, shrkktishid, shrshunnshid, shunnjkykbn, tnphishnsmflg, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, 0 FROM BX_M_051_KSHO_CHIKU_JOHO WHERE shrkbn IN ('01', '02') AND applystrtb <= P_GYOMU_DATE AND applyendb >= P_GYOMU_DATE AND shuhnsts >= 20; GET DIAGNOSTICS V_PROC_CNT_CMT = ROW_COUNT; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区情報 登録件数: ' || V_PROC_CNT_CMT || '件'); CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区情報　登録終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区情報　登録エラー'); RAISE; END; -- 商品情報_切捨 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品情報　削除開始'); TRUNCATE TABLE BX_M_083_TYUKO_SHO_SHO_JOHO; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品情報　削除終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品情報　削除エラー'); RAISE; END; -- 商品情報_登録 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品情報　登録開始'); INSERT INTO BX_M_083_TYUKO_SHO_SHO_JOHO ( shuhnno, applystrtb, applyendb, shrkbn, turkjshrmode, shuhnnmkn, shuhnnmknj, shuhnnmryksyu, tnpyushuhnnmknj, tnpyushuhnnmkn, shuhnkkkhnkk, facekkrdibnricd, facekkrchubnricd, facekkrshubnricd, mkrcd, brndcd, shuhnsizeokyk, shuhnsizehb, shuhnsizetks, shuhnjry, shuhnbnri, hcchukbn, shuhnsts, hpyushuhnstsmi, ntsry, co2histryu, mnzishuhnkbn, urbchnrtssu, urbchnrtsryu, tnpzksibnricd, tnpzksicd, tnpzksikmkcd, shuhnstsmi1, shuhnstsmi2, shuhnstsmi3, shuhnstsmi4, shuhnstsmi5, shuhnstsmi6, shuhnstsmijznhcchuyu, shuhnkntrn, inptyshkbn, inptkbn, ffplutshkbn, nffrnduyucmmnt, oldshuhnno, tnbik, tngnk, nrrts, poskbn, plucd, kgnzirtstshflg, gnkhkkkn, gnkhkkkngnk, irs, caseirs, tkbishuhnkbn, tkbioyfmcd, knrnnshuhncd, cmumkbn, cminfrmtn, grpkbn, shmkgn, hnbikgn, nuhnkgn, hnnmssg, shrkktishid, shrshunnshid, shunnjkykbn, tnphishnsmflg, turkntj, turkshid, turkprgrmid, updtntj, updtshid, updtprgrmid, updtkisu ) SELECT shuhnno, applystrtb, applyendb, shrkbn, turkjshrmode, shuhnnmkn, shuhnnmknj, shuhnnmryksyu, tnpyushuhnnmknj, tnpyushuhnnmkn, shuhnkkkhnkk, facekkrdibnricd, facekkrchubnricd, facekkrshubnricd, mkrcd, brndcd, shuhnsizeokyk, shuhnsizehb, shuhnsizetks, shuhnjry, shuhnbnri, hcchukbn, shuhnsts, hpyushuhnstsmi, ntsry, co2histryu, mnzishuhnkbn, urbchnrtssu, urbchnrtsryu, tnpzksibnricd, tnpzksicd, tnpzksikmkcd, shuhnstsmi1, shuhnstsmi2, shuhnstsmi3, shuhnstsmi4, shuhnstsmi5, shuhnstsmi6, shuhnstsmijznhcchuyu, shuhnkntrn, inptyshkbn, inptkbn, ffplutshkbn, nffrnduyucmmnt, oldshuhnno, tnbik, tngnk, nrrts, poskbn, plucd, kgnzirtstshflg, gnkhkkkn, gnkhkkkngnk, irs, caseirs, tkbishuhnkbn, tkbioyfmcd, knrnnshuhncd, cmumkbn, cminfrmtn, grpkbn, shmkgn, hnbikgn, nuhnkgn, hnnmssg, shrkktishid, shrshunnshid, shunnjkykbn, tnphishnsmflg, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, 0 FROM BX_M_053_KSHO_SHO_JOHO WHERE shrkbn IN ('01', '02') AND applystrtb <= P_GYOMU_DATE AND applyendb >= P_GYOMU_DATE AND shuhnsts >= 20; GET DIAGNOSTICS V_PROC_CNT_CMT = ROW_COUNT; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品情報 登録件数: ' || V_PROC_CNT_CMT || '件'); CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品情報　登録終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品情報　登録エラー'); RAISE; END; -- 商品便別_切捨 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品便別情報　削除開始'); TRUNCATE TABLE BX_M_082_TYUKO_SHO_BIN_JOHO; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品便別情報　削除終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品便別情報　削除エラー'); RAISE; END; -- 商品便別_登録 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品便別情報　登録開始'); INSERT INTO BX_M_082_TYUKO_SHO_BIN_JOHO ( shuhnno, shuhncd, applystrtb, applyendb, shrkbn, turkjshrmode, gndrcd, hnbn, gnbn, gmnhyjzyn, tnphishnsmflg, turkntj, turkshid, turkprgrmid, updtntj, updtshid, updtprgrmid, updtkisu ) SELECT shuhnno, shuhncd, applystrtb, applyendb, shrkbn, turkjshrmode, gndrcd, hnbn, gnbn, gmnhyjzyn, tnphishnsmflg, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, 0 FROM BX_M_052_KSHO_SHO_BIN_JOHO WHERE shrkbn IN ('01', '02') AND applystrtb <= P_GYOMU_DATE AND applyendb >= P_GYOMU_DATE; GET DIAGNOSTICS V_PROC_CNT_CMT = ROW_COUNT; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品便別情報 登録件数: ' || V_PROC_CNT_CMT || '件'); CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品便別情報　登録終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品便別情報　登録エラー'); RAISE; END; -- 地域限定_切捨 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地域限定情報　削除開始'); TRUNCATE TABLE BX_M_079_TYUKO_SHO_CHIKIG_JOHO; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地域限定情報　削除終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地域限定情報　削除エラー'); RAISE; END; -- 地域限定_登録 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地域限定情報　登録開始'); INSERT INTO BX_M_079_TYUKO_SHO_CHIKIG_JOHO ( shuhnno, hcchukbn, chkcd, prefcd, gyumyuprefkkchbcd, shkchsncd3kt, applystrtb, applyendb, turkjshrmode, shrkbn, tnphishnsmflg, turkntj, turkshid, turkprgrmid, updtntj, updtshid, updtprgrmid, updtkisu ) SELECT shuhnno, hcchukbn, chkcd, prefcd, gyumyuprefkkchbcd, shkchsncd3kt, applystrtb, applyendb, turkjshrmode, shrkbn, tnphishnsmflg, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, 0 FROM BX_M_049_KSHO_CHIK_GNTI_JOHO WHERE shrkbn IN ('01', '02') AND applystrtb <= P_GYOMU_DATE AND applyendb >= P_GYOMU_DATE; GET DIAGNOSTICS V_PROC_CNT_CMT = ROW_COUNT; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地域限定情報 登録件数: ' || V_PROC_CNT_CMT || '件'); CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地域限定情報　登録終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地域限定情報　登録エラー'); RAISE; END; -- PLU_切捨 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品PLU変更前マスタ　削除開始'); TRUNCATE TABLE BX_M_085_TYUKO_SHO_PLU_HNK_BF; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品PLU変更前マスタ　削除終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品PLU変更前マスタ　削除エラー'); RAISE; END; -- PLU_登録 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品PLU変更前マスタ　登録開始'); INSERT INTO BX_M_085_TYUKO_SHO_PLU_HNK_BF ( shuhnno, hcchukbn, chkcd, hnkubfrshuhncd, bnkbn, applystrtb, applyendb, shrkbn, turkjshrmode, hnkubfrplucd, hnkuaftrshuhncd, hcchustpkbn, turkntj, turkshid, turkprgrmid, updtntj, updtshid, updtprgrmid, updtkisu ) SELECT shuhnno, hcchukbn, chkcd, hnkubfrshuhncd, bnkbn, applystrtb, applyendb, shrkbn, turkjshrmode, hnkubfrplucd, hnkuaftrshuhncd, hcchustpkbn, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, 0 FROM BX_M_055_KSHO_PLU_HNK_BF WHERE shrkbn IN ('01', '02') AND applystrtb <= P_GYOMU_DATE AND applyendb >= P_GYOMU_DATE; GET DIAGNOSTICS V_PROC_CNT_CMT = ROW_COUNT; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品PLU変更前マスタ 登録件数: ' || V_PROC_CNT_CMT || '件'); CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品PLU変更前マスタ　登録終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品PLU変更前マスタ　登録エラー'); RAISE; END; -- 酒_切捨 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ酒情報　削除開始'); TRUNCATE TABLE BX_M_084_TYUKO_SHO_SAKE_JOHO; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ酒情報　削除終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ酒情報　削除エラー'); RAISE; END; -- 酒_登録 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ酒情報　登録開始'); INSERT INTO BX_M_084_TYUKO_SHO_SAKE_JOHO ( shuhnno, applystrtb, applyendb, shrkbn, turkjshrmode, alchldsu, yry, bkghrtskbn, turkntj, turkshid, turkprgrmid, updtntj, updtshid, updtprgrmid, updtkisu ) SELECT shuhnno, applystrtb, applyendb, shrkbn, turkjshrmode, alchldsu, yry, bkghrtskbn, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, 0 FROM BX_M_054_KSHO_SAKE_JOHO WHERE shrkbn IN ('01', '02') AND applystrtb <= P_GYOMU_DATE AND applyendb >= P_GYOMU_DATE; GET DIAGNOSTICS V_PROC_CNT_CMT = ROW_COUNT; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ酒情報 登録件数: ' || V_PROC_CNT_CMT || '件'); CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ酒情報　登録終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ酒情報　登録エラー'); RAISE; END; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '正常終了 : ' || C_JOB_TITLE); CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, ''); RAISE NOTICE 'exitCd=%', exitCd; EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID P_BATCH_ID, 'PL/PGSQL ERROR:'); CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID P_BATCH_ID, 'SQLSTATE =[' || SQLSTATE || '] [' || SQLERRM || ']'); CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID P_BATCH_ID, '異常終了 : ' || C_JOB_TITLE); CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID P_BATCH_ID, ''); exitCd := 9; RAISE NOTICE 'exitCd=%', exitCd; RAISE; END $$ LANGUAGE plpgsql; 改之后：/* * システム名 ：受発注システム * 機能概要：オンラインテストで扱う商品は、検討商品マスタから作成 * * 引数１ バッチID * 引数２ 業務日付 * */ \set ON_ERROR_STOP on \pset columns 32767 /* ログ出力 */ CREATE OR REPLACE PROCEDURE OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(LEVEL IN CHAR, C_FUNC_ID IN CHAR, P_BATCH_ID IN VARCHAR, MESSAGE IN VARCHAR) AS $$ BEGIN PERFORM DBMS_OUTPUT.SERVEROUTPUT(TRUE); PERFORM DBMS_OUTPUT.PUT_LINE(CLOCK_TIMESTAMP() ||' '|| COALESCE(LEVEL, '') ||' '|| C_FUNC_ID ||' '|| P_BATCH_ID ||' '|| COALESCE(MESSAGE, '') ); END $$ LANGUAGE plpgsql; DO $$ DECLARE C_LOG_LEVEL_INFO CONSTANT char(4) := 'INFO'; C_LOG_LEVEL_ERROR CONSTANT char(5) := 'ERROR'; C_FUNC_ID CONSTANT char(3) := 'OTL'; C_JOB_TITLE CONSTANT varchar(256) := '検討商品マスタ取込'; P_BATCH_ID varchar(256) := current_setting('custom.batch_id'); -- バッチID P_GYOMU_DATE varchar(8) := current_setting('custom.gyomu_date'); -- 業務日付 /* 変数 */ V_PROC_CNT_CMT numeric := 0; -- 処理件数 exitCd INTEGER = 0; BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '検討商品マスタ取込 登録開始'); -- 地区便_切捨 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区便情報　削除開始'); TRUNCATE TABLE BX_M_080_TYUKO_SHO_CHIKUB_JOHO; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区便情報　削除終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区便情報　削除エラー'); RAISE; END; -- 地区便_登録 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区便情報　登録開始'); INSERT INTO BX_M_080_TYUKO_SHO_CHIKUB_JOHO ( shuhnno, hcchukbn, chkcd, shuhncd, bnkbn, applystrtb, applyendb, shrkbn, turkjshrmode, tkbishuhnkbn, tkbioyfmcd, brshuhncd, hcchustrtb, hcchustpstrtb, hcchustpendb, trkshb, trkshkbn, shuhntrkshrasnkbn, hcchushrtnikbn, mnmmhcchubsu, mxmmhcchubsu, plucd, plucdhnkuumkbn, poskbn, knrnnshuhncd, tnphishnsmflg, turkntj, turkshid, turkprgrmid, updtntj, updtshid, updtprgrmid, updtkisu ) SELECT shuhnno, hcchukbn, chkcd, shuhncd, bnkbn, applystrtb, applyendb, shrkbn, turkjshrmode, tkbishuhnkbn, NULLIF(tkbioyfmcd, ''), NULLIF(brshuhncd, ''), NULLIF(hcchustrtb, ''), NULLIF(hcchustpstrtb, ''), NULLIF(hcchustpendb, ''), NULLIF(trkshb, ''), NULLIF(trkshkbn, ''), NULLIF(shuhntrkshrasnkbn, ''), hcchushrtnikbn, mnmmhcchubsu, mxmmhcchubsu, NULLIF(plucd, ''), plucdhnkuumkbn, poskbn, NULLIF(knrnnshuhncd, ''), tnphishnsmflg, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, 0 FROM BX_M_050_KSHO_CHIKU_BIN_JOHO WHERE shrkbn IN ('01', '02') AND applystrtb <= P_GYOMU_DATE AND applyendb >= P_GYOMU_DATE; GET DIAGNOSTICS V_PROC_CNT_CMT = ROW_COUNT; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区便情報 登録件数: ' || V_PROC_CNT_CMT || '件'); CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区便情報　登録終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区便情報　登録エラー'); RAISE; END; -- 地区_切捨 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区情報　削除開始'); TRUNCATE TABLE BX_M_081_TYUKO_SHO_CHIKU_JOHO; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区情報　削除終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区情報　削除エラー'); RAISE; END; -- 地区_登録 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区情報　登録開始'); INSERT INTO BX_M_081_TYUKO_SHO_CHIKU_JOHO ( shuhnno, hcchukbn, chkcd, applystrtb, applyendb, shrkbn, turkjshrmode, cmumkbn, cminfrmtn, grpkbn, shuhnstsmi1, shuhnstsmi2, shuhnstsmi3, shuhnstsmi4, shuhnstsmi5, shuhnstsmi6, dsgnpckghnkuarflg, shuhnstsmipckghnkuyu, irs, caseirs, setirs, brshuhncd, setbrkbn, zikshbninfrmtnkbn, hnpnkknstrtb, hnpnkknendb, shuhncmmnt, bik, nrrts, tsjgnk, gnkhkkkn, gnkhkkkngnk, shryutrhkskcd, mkrcd, brndcd, linkyukukbn, shuhnturkyudepotcd, hssipttrn, sshkehhkbn, sshkeshuhncd, sshkeshuhnnmknj, shuhnhnkurasnkbn, kntgiturkb, shuhnrank, hyjnfaceumkbn, nwshuhnflg, newkbn, nryrkbn, inptkbn, bikhnkukbn, shkiturkb, hssshuhnflg, dphngzuhishnflg, shuhnsts, shmkgn, hnbikgn, nuhnkgn, sitiziksu, mrktngnewshkkub, mrktngnewsgsu, mrktngnewsksikbn, mrktngnewshknb, dichuhyjkbn, hcchustpkbn, hnnmssg, ffhnbikgntm, ffhnbikgntshgiflg, untgrupcd, shrkktishid, shrshunnshid, shunnjkykbn, tnphishnsmflg, turkntj, turkshid, turkprgrmid, updtntj, updtshid, updtprgrmid, updtkisu ) SELECT shuhnno, hcchukbn, chkcd, applystrtb, applyendb, shrkbn, turkjshrmode, cmumkbn, NULLIF(cminfrmtn, ''), NULLIF(grpkbn, ''), NULLIF(shuhnstsmi1, ''), NULLIF(shuhnstsmi2, ''), NULLIF(shuhnstsmi3, ''), NULLIF(shuhnstsmi4, ''), NULLIF(shuhnstsmi5, ''), NULLIF(shuhnstsmi6, ''), dsgnpckghnkuarflg, NULLIF(shuhnstsmipckghnkuyu, ''), irs, caseirs, setirs, NULLIF(brshuhncd, ''), setbrkbn, NULLIF(zikshbninfrmtnkbn, ''), NULLIF(hnpnkknstrtb, ''), NULLIF(hnpnkknendb, ''), NULLIF(shuhncmmnt, ''), bik, nrrts, tsjgnk, NULLIF(gnkhkkkn, ''), gnkhkkkngnk, NULLIF(shryutrhkskcd, ''), mkrcd, brndcd, linkyukukbn, NULLIF(shuhnturkyudepotcd, ''), NULLIF(hssipttrn, ''), NULLIF(sshkehhkbn, ''), NULLIF(sshkeshuhncd, ''), NULLIF(sshkeshuhnnmknj, ''), NULLIF(shuhnhnkurasnkbn, ''), NULLIF(kntgiturkb, ''), NULLIF(shuhnrank, ''), hyjnfaceumkbn, nwshuhnflg, newkbn, nryrkbn, inptkbn, bikhnkukbn, NULLIF(shkiturkb, ''), hssshuhnflg, dphngzuhishnflg, shuhnsts, shmkgn, hnbikgn, nuhnkgn, sitiziksu, NULLIF(mrktngnewshkkub, ''), mrktngnewsgsu, mrktngnewsksikbn, NULLIF(mrktngnewshknb, ''), dichuhyjkbn, hcchustpkbn, NULLIF(hnnmssg, ''), ffhnbikgntm, ffhnbikgntshgiflg, NULLIF(untgrupcd, ''), NULLIF(shrkktishid, ''), NULLIF(shrshunnshid, ''), NULLIF(shunnjkykbn, ''), tnphishnsmflg, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, 0 FROM BX_M_051_KSHO_CHIKU_JOHO WHERE shrkbn IN ('01', '02') AND applystrtb <= P_GYOMU_DATE AND applyendb >= P_GYOMU_DATE AND CAST(shuhnsts AS integer) >= 20; GET DIAGNOSTICS V_PROC_CNT_CMT = ROW_COUNT; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区情報 登録件数: ' || V_PROC_CNT_CMT || '件'); CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区情報　登録終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地区情報　登録エラー'); RAISE; END; -- 商品情報_切捨 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品情報　削除開始'); TRUNCATE TABLE BX_M_083_TYUKO_SHO_SHO_JOHO; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品情報　削除終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品情報　削除エラー'); RAISE; END; -- 商品情報_登録 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品情報　登録開始'); INSERT INTO BX_M_083_TYUKO_SHO_SHO_JOHO ( shuhnno, applystrtb, applyendb, shrkbn, turkjshrmode, shuhnnmkn, shuhnnmknj, shuhnnmryksyu, tnpyushuhnnmknj, tnpyushuhnnmkn, shuhnkkkhnkk, facekkrdibnricd, facekkrchubnricd, facekkrshubnricd, mkrcd, brndcd, shuhnsizeokyk, shuhnsizehb, shuhnsizetks, shuhnjry, shuhnbnri, hcchukbn, shuhnsts, hpyushuhnstsmi, ntsry, co2histryu, mnzishuhnkbn, urbchnrtssu, urbchnrtsryu, tnpzksibnricd, tnpzksicd, tnpzksikmkcd, shuhnstsmi1, shuhnstsmi2, shuhnstsmi3, shuhnstsmi4, shuhnstsmi5, shuhnstsmi6, shuhnstsmijznhcchuyu, shuhnkntrn, inptyshkbn, inptkbn, ffplutshkbn, nffrnduyucmmnt, oldshuhnno, tnbik, tngnk, nrrts, poskbn, plucd, kgnzirtstshflg, gnkhkkkn, gnkhkkkngnk, irs, caseirs, tkbishuhnkbn, tkbioyfmcd, knrnnshuhncd, cmumkbn, cminfrmtn, grpkbn, shmkgn, hnbikgn, nuhnkgn, hnnmssg, shrkktishid, shrshunnshid, shunnjkykbn, tnphishnsmflg, turkntj, turkshid, turkprgrmid, updtntj, updtshid, updtprgrmid, updtkisu ) SELECT shuhnno, applystrtb, applyendb, shrkbn, turkjshrmode, NULLIF(shuhnnmkn, ''), NULLIF(shuhnnmknj, ''), NULLIF(shuhnnmryksyu, ''), NULLIF(tnpyushuhnnmknj, ''), NULLIF(tnpyushuhnnmkn, ''), NULLIF(shuhnkkkhnkk, ''), NULLIF(facekkrdibnricd, ''), NULLIF(facekkrchubnricd, ''), NULLIF(facekkrshubnricd, ''), mkrcd, brndcd, shuhnsizeokyk, shuhnsizehb, shuhnsizetks, shuhnjry, NULLIF(shuhnbnri, ''), hcchukbn, shuhnsts, NULLIF(hpyushuhnstsmi, ''), ntsry, co2histryu, mnzishuhnkbn, urbchnrtssu, urbchnrtsryu, NULLIF(tnpzksibnricd, ''), NULLIF(tnpzksicd, ''), NULLIF(tnpzksikmkcd, ''), NULLIF(shuhnstsmi1, ''), NULLIF(shuhnstsmi2, ''), NULLIF(shuhnstsmi3, ''), NULLIF(shuhnstsmi4, ''), NULLIF(shuhnstsmi5, ''), NULLIF(shuhnstsmi6, ''), NULLIF(shuhnstsmijznhcchuyu, ''), NULLIF(shuhnkntrn, ''), inptyshkbn, inptkbn, ffplutshkbn, NULLIF(nffrnduyucmmnt, ''), oldshuhnno, tnbik, tngnk, nrrts, poskbn, NULLIF(plucd, ''), kgnzirtstshflg, NULLIF(gnkhkkkn, ''), gnkhkkkngnk, irs, caseirs, tkbishuhnkbn, NULLIF(tkbioyfmcd, ''), NULLIF(knrnnshuhncd, ''), cmumkbn, cminfrmtn,NULLIF(cminfrmtn, ''), NULLIF(grpkbn, ''), shmkgn, hnbikgn, nuhnkgn, NULLIF(hnnmssg, ''), NULLIF(shrkktishid, ''), NULLIF(shrshunnshid, ''), NULLIF(shunnjkykbn, ''), tnphishnsmflg, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, 0 FROM BX_M_053_KSHO_SHO_JOHO WHERE shrkbn IN ('01', '02') AND applystrtb <= P_GYOMU_DATE AND applyendb >= P_GYOMU_DATE AND CAST(shuhnsts AS integer) >= '20'; GET DIAGNOSTICS V_PROC_CNT_CMT = ROW_COUNT; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品情報 登録件数: ' || V_PROC_CNT_CMT || '件'); CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品情報　登録終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品情報　登録エラー'); RAISE; END; -- 商品便別_切捨 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品便別情報　削除開始'); TRUNCATE TABLE BX_M_082_TYUKO_SHO_BIN_JOHO; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品便別情報　削除終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品便別情報　削除エラー'); RAISE; END; -- 商品便別_登録 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品便別情報　登録開始'); INSERT INTO BX_M_082_TYUKO_SHO_BIN_JOHO ( shuhnno, shuhncd, applystrtb, applyendb, shrkbn, turkjshrmode, gndrcd, hnbn, gnbn, gmnhyjzyn, tnphishnsmflg, turkntj, turkshid, turkprgrmid, updtntj, updtshid, updtprgrmid, updtkisu ) SELECT shuhnno, shuhncd, applystrtb, applyendb, shrkbn, turkjshrmode, NULLIF(gndrcd, ''), NULLIF(hnbn, ''), NULLIF(gnbn, ''), gmnhyjzyn, tnphishnsmflg, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, 0 FROM BX_M_052_KSHO_SHO_BIN_JOHO WHERE shrkbn IN ('01', '02') AND applystrtb <= P_GYOMU_DATE AND applyendb >= P_GYOMU_DATE; GET DIAGNOSTICS V_PROC_CNT_CMT = ROW_COUNT; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品便別情報 登録件数: ' || V_PROC_CNT_CMT || '件'); CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品便別情報　登録終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ商品便別情報　登録エラー'); RAISE; END; -- 地域限定_切捨 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地域限定情報　削除開始'); TRUNCATE TABLE BX_M_079_TYUKO_SHO_CHIKIG_JOHO; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地域限定情報　削除終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地域限定情報　削除エラー'); RAISE; END; -- 地域限定_登録 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地域限定情報　登録開始'); INSERT INTO BX_M_079_TYUKO_SHO_CHIKIG_JOHO ( shuhnno, hcchukbn, chkcd, prefcd, gyumyuprefkkchbcd, shkchsncd3kt, applystrtb, applyendb, turkjshrmode, shrkbn, tnphishnsmflg, turkntj, turkshid, turkprgrmid, updtntj, updtshid, updtprgrmid, updtkisu ) SELECT shuhnno, hcchukbn, chkcd, prefcd, gyumyuprefkkchbcd, shkchsncd3kt, applystrtb, applyendb, turkjshrmode, shrkbn, tnphishnsmflg, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, 0 FROM BX_M_049_KSHO_CHIK_GNTI_JOHO WHERE shrkbn IN ('01', '02') AND applystrtb <= P_GYOMU_DATE AND applyendb >= P_GYOMU_DATE; GET DIAGNOSTICS V_PROC_CNT_CMT = ROW_COUNT; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地域限定情報 登録件数: ' || V_PROC_CNT_CMT || '件'); CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地域限定情報　登録終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ地域限定情報　登録エラー'); RAISE; END; -- PLU_切捨 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品PLU変更前マスタ　削除開始'); TRUNCATE TABLE BX_M_085_TYUKO_SHO_PLU_HNK_BF; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品PLU変更前マスタ　削除終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品PLU変更前マスタ　削除エラー'); RAISE; END; -- PLU_登録 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品PLU変更前マスタ　登録開始'); INSERT INTO BX_M_085_TYUKO_SHO_PLU_HNK_BF ( shuhnno, hcchukbn, chkcd, hnkubfrshuhncd, bnkbn, applystrtb, applyendb, shrkbn, turkjshrmode, hnkubfrplucd, hnkuaftrshuhncd, hcchustpkbn, turkntj, turkshid, turkprgrmid, updtntj, updtshid, updtprgrmid, updtkisu ) SELECT shuhnno, hcchukbn, chkcd, hnkubfrshuhncd, bnkbn, applystrtb, applyendb, shrkbn, turkjshrmode, NULLIF(hnkubfrplucd, ''), NULLIF(hnkuaftrshuhncd, ''), hcchustpkbn, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, 0 FROM BX_M_055_KSHO_PLU_HNK_BF WHERE shrkbn IN ('01', '02') AND applystrtb <= P_GYOMU_DATE AND applyendb >= P_GYOMU_DATE; GET DIAGNOSTICS V_PROC_CNT_CMT = ROW_COUNT; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品PLU変更前マスタ 登録件数: ' || V_PROC_CNT_CMT || '件'); CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品PLU変更前マスタ　登録終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品PLU変更前マスタ　登録エラー'); RAISE; END; -- 酒_切捨 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ酒情報　削除開始'); TRUNCATE TABLE BX_M_084_TYUKO_SHO_SAKE_JOHO; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ酒情報　削除終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ酒情報　削除エラー'); RAISE; END; -- 酒_登録 BEGIN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ酒情報　登録開始'); INSERT INTO BX_M_084_TYUKO_SHO_SAKE_JOHO ( shuhnno, applystrtb, applyendb, shrkbn, turkjshrmode, alchldsu, yry, bkghrtskbn, turkntj, turkshid, turkprgrmid, updtntj, updtshid, updtprgrmid, updtkisu ) SELECT shuhnno, applystrtb, applyendb, shrkbn, turkjshrmode, alchldsu, yry, NULLIF(bkghrtskbn, ''), CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, 0 FROM BX_M_054_KSHO_SAKE_JOHO WHERE shrkbn IN ('01', '02') AND applystrtb <= P_GYOMU_DATE AND applyendb >= P_GYOMU_DATE; GET DIAGNOSTICS V_PROC_CNT_CMT = ROW_COUNT; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ酒情報 登録件数: ' || V_PROC_CNT_CMT || '件'); CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ酒情報　登録終了'); EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '当日有効商品マスタ酒情報　登録エラー'); RAISE; END; CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, '正常終了 : ' || C_JOB_TITLE); CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_INFO, C_FUNC_ID, P_BATCH_ID, ''); RAISE NOTICE 'exitCd=%', exitCd; EXCEPTION WHEN OTHERS THEN CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, 'PL/PGSQL ERROR:'); CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, 'SQLSTATE =[' || SQLSTATE || '] [' || SQLERRM || ']'); CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, '異常終了 : ' || C_JOB_TITLE); CALL OUTPUT_LOG_MESSAGE_B_BX_OLT01_020(C_LOG_LEVEL_ERROR, C_FUNC_ID, P_BATCH_ID, ''); exitCd := 9; RAISE NOTICE 'exitCd=%', exitCd; RAISE; END $$ LANGUAGE plpgsql;报错： 2025/10/18 13:35:38 INFO ================================================ 2025/10/18 13:35:38 INFO ----- Log Message Start ----- 2025/10/18 13:35:38 INFO BATCH NAME = 検討商品マスタ取込 2025/10/18 13:35:38 INFO BATCH ID = B_BX_OLT01_020 2025/10/18 13:35:38 INFO 業務日付 = 20250904 exitCd=-1 psql:/home/bx01/git/bx-db-server/program/svol01/bj/bin/sh/sql/bx_ins_B_BX_OLT01_020.sql:844: 2025-10-18 13:35:38.450038+09 INFO OTL B_BX_OLT01_020 検討商品マスタ取込 登録開始 psql:/home/bx01/git/bx-db-server/program/svol01/bj/bin/sh/sql/bx_ins_B_BX_OLT01_020.sql:844: 2025-10-18 13:35:38.450252+09 INFO OTL B_BX_OLT01_020 当日有効商品マスタ地区便情報　削除開始 psql:/home/bx01/git/bx-db-server/program/svol01/bj/bin/sh/sql/bx_ins_B_BX_OLT01_020.sql:844: 2025-10-18 13:35:38.452166+09 INFO OTL B_BX_OLT01_020 当日有効商品マスタ地区便情報　削除終了 psql:/home/bx01/git/bx-db-server/program/svol01/bj/bin/sh/sql/bx_ins_B_BX_OLT01_020.sql:844: 2025-10-18 13:35:38.452347+09 INFO OTL B_BX_OLT01_020 当日有効商品マスタ地区便情報　登録開始 psql:/home/bx01/git/bx-db-server/program/svol01/bj/bin/sh/sql/bx_ins_B_BX_OLT01_020.sql:844: 2025-10-18 13:35:38.455285+09 INFO OTL B_BX_OLT01_020 当日有効商品マスタ地区便情報 登録件数: 3件 psql:/home/bx01/git/bx-db-server/program/svol01/bj/bin/sh/sql/bx_ins_B_BX_OLT01_020.sql:844: 2025-10-18 13:35:38.455455+09 INFO OTL B_BX_OLT01_020 当日有効商品マスタ地区便情報　登録終了 psql:/home/bx01/git/bx-db-server/program/svol01/bj/bin/sh/sql/bx_ins_B_BX_OLT01_020.sql:844: 2025-10-18 13:35:38.455648+09 INFO OTL B_BX_OLT01_020 当日有効商品マスタ地区情報　削除開始 psql:/home/bx01/git/bx-db-server/program/svol01/bj/bin/sh/sql/bx_ins_B_BX_OLT01_020.sql:844: 2025-10-18 13:35:38.457479+09 INFO OTL B_BX_OLT01_020 当日有効商品マスタ地区情報　削除終了 psql:/home/bx01/git/bx-db-server/program/svol01/bj/bin/sh/sql/bx_ins_B_BX_OLT01_020.sql:844: 2025-10-18 13:35:38.457605+09 INFO OTL B_BX_OLT01_020 当日有効商品マスタ地区情報　登録開始 psql:/home/bx01/git/bx-db-server/program/svol01/bj/bin/sh/sql/bx_ins_B_BX_OLT01_020.sql:844: 2025-10-18 13:35:38.45991+09 INFO OTL B_BX_OLT01_020 当日有効商品マスタ地区情報 登録件数: 3件 psql:/home/bx01/git/bx-db-server/program/svol01/bj/bin/sh/sql/bx_ins_B_BX_OLT01_020.sql:844: 2025-10-18 13:35:38.460032+09 INFO OTL B_BX_OLT01_020 当日有効商品マスタ地区情報　登録終了 psql:/home/bx01/git/bx-db-server/program/svol01/bj/bin/sh/sql/bx_ins_B_BX_OLT01_020.sql:844: 2025-10-18 13:35:38.460109+09 INFO OTL B_BX_OLT01_020 当日有効商品マスタ商品情報　削除開始 psql:/home/bx01/git/bx-db-server/program/svol01/bj/bin/sh/sql/bx_ins_B_BX_OLT01_020.sql:844: 2025-10-18 13:35:38.461652+09 INFO OTL B_BX_OLT01_020 当日有効商品マスタ商品情報　削除終了 psql:/home/bx01/git/bx-db-server/program/svol01/bj/bin/sh/sql/bx_ins_B_BX_OLT01_020.sql:844: 2025-10-18 13:35:38.461766+09 INFO OTL B_BX_OLT01_020 当日有効商品マスタ商品情報　登録開始 psql:/home/bx01/git/bx-db-server/program/svol01/bj/bin/sh/sql/bx_ins_B_BX_OLT01_020.sql:844: 2025-10-18 13:35:38.462309+09 ERROR OTL B_BX_OLT01_020 当日有効商品マスタ商品情報　登録エラー psql:/home/bx01/git/bx-db-server/program/svol01/bj/bin/sh/sql/bx_ins_B_BX_OLT01_020.sql:844: 2025-10-18 13:35:38.463678+09 ERROR OTL B_BX_OLT01_020 PL/PGSQL ERROR: psql:/home/bx01/git/bx-db-server/program/svol01/bj/bin/sh/sql/bx_ins_B_BX_OLT01_020.sql:844: 2025-10-18 13:35:38.463809+09 ERROR OTL B_BX_OLT01_020 SQLSTATE =[42601] [INSERT has more expressions than target columns] psql:/home/bx01/git/bx-db-server/program/svol01/bj/bin/sh/sql/bx_ins_B_BX_OLT01_020.sql:844: 2025-10-18 13:35:38.463917+09 ERROR OTL B_BX_OLT01_020 異常終了 : 検討商品マスタ取込 psql:/home/bx01/git/bx-db-server/program/svol01/bj/bin/sh/sql/bx_ins_B_BX_OLT01_020.sql:844: 2025-10-18 13:35:38.464006+09 ERROR OTL B_BX_OLT01_020 psql:/home/bx01/git/bx-db-server/program/svol01/bj/bin/sh/sql/bx_ins_B_BX_OLT01_020.sql:844: NOTICE: exitCd=9 psql:/home/bx01/git/bx-db-server/program/svol01/bj/bin/sh/sql/bx_ins_B_BX_OLT01_020.sql:844: ERROR: INSERT has more expressions than target columns LINE 155: 0 ^ QUERY: INSERT INTO BX_M_083_TYUKO_SHO_SHO_JOHO ( shuhnno, applystrtb, applyendb, shrkbn, turkjshrmode, shuhnnmkn, shuhnnmknj, shuhnnmryksyu, tnpyushuhnnmknj, tnpyushuhnnmkn, shuhnkkkhnkk, facekkrdibnricd, facekkrchubnricd, facekkrshubnricd, mkrcd, brndcd, shuhnsizeokyk, shuhnsizehb, shuhnsizetks, shuhnjry, shuhnbnri, hcchukbn, shuhnsts, hpyushuhnstsmi, ntsry, co2histryu, mnzishuhnkbn, urbchnrtssu, urbchnrtsryu, tnpzksibnricd, tnpzksicd, tnpzksikmkcd, shuhnstsmi1, shuhnstsmi2, shuhnstsmi3, shuhnstsmi4, shuhnstsmi5, shuhnstsmi6, shuhnstsmijznhcchuyu, shuhnkntrn, inptyshkbn, inptkbn, ffplutshkbn, nffrnduyucmmnt, oldshuhnno, tnbik, tngnk, nrrts, poskbn, plucd, kgnzirtstshflg, gnkhkkkn, gnkhkkkngnk, irs, caseirs, tkbishuhnkbn, tkbioyfmcd, knrnnshuhncd, cmumkbn, cminfrmtn, grpkbn, shmkgn, hnbikgn, nuhnkgn, hnnmssg, shrkktishid, shrshunnshid, shunnjkykbn, tnphishnsmflg, turkntj, turkshid, turkprgrmid, updtntj, updtshid, updtprgrmid, updtkisu ) SELECT shuhnno, applystrtb, applyendb, shrkbn, turkjshrmode, NULLIF(shuhnnmkn, ''), NULLIF(shuhnnmknj, ''), NULLIF(shuhnnmryksyu, ''), NULLIF(tnpyushuhnnmknj, ''), NULLIF(tnpyushuhnnmkn, ''), NULLIF(shuhnkkkhnkk, ''), NULLIF(facekkrdibnricd, ''), NULLIF(facekkrchubnricd, ''), NULLIF(facekkrshubnricd, ''), mkrcd, brndcd, shuhnsizeokyk, shuhnsizehb, shuhnsizetks, shuhnjry, NULLIF(shuhnbnri, ''), hcchukbn, shuhnsts, NULLIF(hpyushuhnstsmi, ''), ntsry, co2histryu, mnzishuhnkbn, urbchnrtssu, urbchnrtsryu, NULLIF(tnpzksibnricd, ''), NULLIF(tnpzksicd, ''), NULLIF(tnpzksikmkcd, ''), NULLIF(shuhnstsmi1, ''), NULLIF(shuhnstsmi2, ''), NULLIF(shuhnstsmi3, ''), NULLIF(shuhnstsmi4, ''), NULLIF(shuhnstsmi5, ''), NULLIF(shuhnstsmi6, ''), NULLIF(shuhnstsmijznhcchuyu, ''), NULLIF(shuhnkntrn, ''), inptyshkbn, inptkbn, ffplutshkbn, NULLIF(nffrnduyucmmnt, ''), oldshuhnno, tnbik, tngnk, nrrts, poskbn, NULLIF(plucd, ''), kgnzirtstshflg, NULLIF(gnkhkkkn, ''), gnkhkkkngnk, irs, caseirs, tkbishuhnkbn, NULLIF(tkbioyfmcd, ''), NULLIF(knrnnshuhncd, ''), cmumkbn, cminfrmtn,NULLIF(cminfrmtn, ''), NULLIF(grpkbn, ''), shmkgn, hnbikgn, nuhnkgn, NULLIF(hnnmssg, ''), NULLIF(shrkktishid, ''), NULLIF(shrshunnshid, ''), NULLIF(shunnjkykbn, ''), tnphishnsmflg, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, CLOCK_TIMESTAMP(), P_BATCH_ID, P_BATCH_ID, 0 FROM BX_M_053_KSHO_SHO_JOHO WHERE shrkbn IN ('01', '02') AND applystrtb <= P_GYOMU_DATE AND applyendb >= P_GYOMU_DATE AND CAST(shuhnsts AS integer) >= '20' CONTEXT: PL/pgSQL function inline_code_block line 337 at SQL statement 2025/10/18 13:35:38 ERROR プログラムが異常終了しました。 2025/10/18 13:35:38 INFO ----- Log Message End -----
最新发布
10-19
从报错信息来看，问题出在 `INSERT INTO BX_M_083_TYUKO_SHO_SHO_JOHO` 语句中，错误提示为 **"INSERT has more expressions than target columns"**，即 **SELECT 子句中的列数多于目标表的列数**。...
terminate called after throwing an instance of 'otl_tmpl_exception＜otl_exc, otl_conn, otl_cur>`解决方法
WorldMvp的专栏
01-16 3531
在linux下用c++连接MySQL或oracle数据库时，若频繁调用otlstream构造函数，发生 terminate called after throwing an instance of 'otl_tmpl_exception＜otl_exc, otl_conn, otl_cur>`的问题，其解决方法为：
OTL 4.0, OTL defined exceptions
波波诸葛伟
10-29 4001
OTL 4.0, OTL defined exceptions OTL defined exceptions The following OTL exceptions can be raised by the OTL stream functions: Code=32000: Incompatible data types in stream operation Cause: 
terminate called after throwing an instance of 'otl_tmpl_exception<otl_exc, otl_conn, otl_cur>'
liang12360640的专栏
06-14 2152
mysql解决terminate called after throwing an instance of 'otl_tmpl_exception'     记录一个问题解决过程：     近日发现，频繁调用基于gsoap编写的webservice接口，程序会偶尔卡死，且无错误日志输出，进程仍然存在初步判断为死锁导致，跟进分析代码后发现初始化mysql数据库连接的地方有较大嫌疑，用的是otlv
OTL 4.0, OTL stream class
kanwoerzi
10-09 409
OTL stream class otl_strean类 具体的实现了OTL 流的概念。任何的SQL语句、SQL语句块和存储过程都能通过otl_stream进行处理。 传统的数据库API处理SQL语句的时候，需要绑定变量与占位符。所以，开发者需要声明主数组在程序中So, the developer has to declare host arrays in the program,解析语...
简单使用OTL进行数据库编程
云魂工作室-AKAI
05-16 775
#define OTL_ODBC#include "otlv4.h" 连接 otl_connect db; otl_connect::otl_initialize(); db.rlogon("Driver={Microsoft ODBC for Oracle};Server=kmjy;Uid=akai;Pwd=123456;");   //通过ODBC连接ORACLE数据库 
OTL之oralce开发总结
FoxBryant的专栏
10-16 8670
关于OTL，网上介绍的也不少，但看来看去也只是官方的那些文档。OTL很好用，结合官方提供的一些例子，多多尝试才能领悟。经过一个月左右的项目开发，对OTL也有些了解，在这里总结一下，希望对刚接触OTL的新手有所帮助。其中有些地方，比如对网络异常的处理，可是费了我两天的时间才解决的，
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值