2013-03-18 14:52:52 【 INFO】 SELECT CODE, NAME FROM COMMON WHERE MASTER_CODE_STR = '00010016' AND CONDITION_FLG = 0 AND LAST_FLG = 1 AND CODE != 0 ORDER BY CODE 2013-03-18 16:06:46 【 INFO】 SELECT SET_NO CODE ,NAME || DECODE(SET_KIND,0,'(院内共通)',1,'('|| SECTION_NAME ||')',2,'('|| TARGET_UNAME ||')','') NAME FROM ORDER_SET WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = 1 AND ORDER_KIND_CODE_STR IN ('0502','0521','0522','0523','0524','0525','0526') AND NAME LIKE '%' || :B_NAME || '%' ORDER BY 2,1 2013-03-18 19:01:03 【 INFO】 SELECT SET_NO CODE ,NAME || DECODE(SET_KIND,0,'(院内共通)',1,'('|| SECTION_NAME ||')',2,'('|| TARGET_UNAME ||')','') NAME FROM ORDER_SET WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = 1 AND ORDER_KIND_CODE_STR IN ('0502','0521','0522','0523','0524','0525','0526') AND NAME LIKE '%' || :B_NAME || '%' ORDER BY 2,1 2013-03-18 19:02:16 【 INFO】 SELECT SET_NO CODE ,'[' SET_NO ']'|| NAME || DECODE(SET_KIND,0,'(院内共通)',1,'('|| SECTION_NAME ||')',2,'('|| TARGET_UNAME ||')','') NAME FROM ORDER_SET WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = 1 AND ORDER_KIND_CODE_STR IN ('0502','0521','0522','0523','0524','0525','0526') AND NAME LIKE '%' || :B_NAME || '%' ORDER BY 2,1 2013-03-18 19:02:16 【 INFO】 exception 'Zend_Db_Statement_Oracle_Exception' with message '923 ORA-00923: FROMキーワードが指定の位置にありません。 SELECT SET_NO CODE ,'[' SET_NO *']'|| NAME || DECODE(SET_KIND,0,'(院内共通)',1,'('|| SECTION_NAME ||')',2,'('|| TARGET_UNAME ||')','') NAME FROM ORDER_SET WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = 1 AND ORDER_KIND_CODE_STR IN ('0502','0521','0522','0523','0524','0525','0526') AND NAME LIKE '%' || :B_NAME || '%' ORDER BY 2,1 ' in C:\Program Files\PHP\includes\Zend\Db\Statement\Oracle.php:244 Stack trace: #0 C:\Program Files\PHP\includes\Zend\Db\Statement.php(283): Zend_Db_Statement_Oracle->_execute(Array) #1 C:\Program Files\PHP\includes\Zend\Db\Adapter\Abstract.php(405): Zend_Db_Statement->execute(Array) #2 C:\Program Files\PHP\includes\Zend\Db\Adapter\Abstract.php(616): Zend_Db_Adapter_Abstract->query('???????SELECT??...', Array) #3 C:\php_eclipse\workspace\ShinryoShien\shinryo_shien\tools\sbs_db_access.php(68): Zend_Db_Adapter_Abstract->fetchAll('???????SELECT??...', Array) #4 C:\php_eclipse\workspace\ShinryoShien\shinryo_shien\models\item_search\is_master_model.php(2090): SBSDBAccess->fetchAll('???????SELECT??...', Array) #5 C:\php_eclipse\workspace\ShinryoShien\shinryo_shien\windows\select_common.php(355): IsMasterModel->getDocSetList('???Y?^') #6 {main} 2013-03-18 19:02:18 【 INFO】 SELECT SET_NO CODE ,'[' SET_NO ']'|| NAME || DECODE(SET_KIND,0,'(院内共通)',1,'('|| SECTION_NAME ||')',2,'('|| TARGET_UNAME ||')','') NAME FROM ORDER_SET WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = 1 AND ORDER_KIND_CODE_STR IN ('0502','0521','0522','0523','0524','0525','0526') AND NAME LIKE '%' || :B_NAME || '%' ORDER BY 2,1 2013-03-18 19:02:19 【 INFO】 exception 'Zend_Db_Statement_Oracle_Exception' with message '923 ORA-00923: FROMキーワードが指定の位置にありません。 SELECT SET_NO CODE ,'[' SET_NO *']'|| NAME || DECODE(SET_KIND,0,'(院内共通)',1,'('|| SECTION_NAME ||')',2,'('|| TARGET_UNAME ||')','') NAME FROM ORDER_SET WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = 1 AND ORDER_KIND_CODE_STR IN ('0502','0521','0522','0523','0524','0525','0526') AND NAME LIKE '%' || :B_NAME || '%' ORDER BY 2,1 ' in C:\Program Files\PHP\includes\Zend\Db\Statement\Oracle.php:244 Stack trace: #0 C:\Program Files\PHP\includes\Zend\Db\Statement.php(283): Zend_Db_Statement_Oracle->_execute(Array) #1 C:\Program Files\PHP\includes\Zend\Db\Adapter\Abstract.php(405): Zend_Db_Statement->execute(Array) #2 C:\Program Files\PHP\includes\Zend\Db\Adapter\Abstract.php(616): Zend_Db_Adapter_Abstract->query('???????SELECT??...', Array) #3 C:\php_eclipse\workspace\ShinryoShien\shinryo_shien\tools\sbs_db_access.php(68): Zend_Db_Adapter_Abstract->fetchAll('???????SELECT??...', Array) #4 C:\php_eclipse\workspace\ShinryoShien\shinryo_shien\models\item_search\is_master_model.php(2090): SBSDBAccess->fetchAll('???????SELECT??...', Array) #5 C:\php_eclipse\workspace\ShinryoShien\shinryo_shien\windows\select_common.php(355): IsMasterModel->getDocSetList('???Y?^') #6 {main} 2013-03-18 19:02:33 【 INFO】 SELECT SET_NO CODE ,'[' SET_NO ']'|| NAME || DECODE(SET_KIND,0,'(院内共通)',1,'('|| SECTION_NAME ||')',2,'('|| TARGET_UNAME ||')','') NAME FROM ORDER_SET WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = 1 AND ORDER_KIND_CODE_STR IN ('0502','0521','0522','0523','0524','0525','0526') AND NAME LIKE '%' || :B_NAME || '%' ORDER BY 2,1 2013-03-18 19:02:33 【 INFO】 exception 'Zend_Db_Statement_Oracle_Exception' with message '923 ORA-00923: FROMキーワードが指定の位置にありません。 SELECT SET_NO CODE ,'[' SET_NO *']'|| NAME || DECODE(SET_KIND,0,'(院内共通)',1,'('|| SECTION_NAME ||')',2,'('|| TARGET_UNAME ||')','') NAME FROM ORDER_SET WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = 1 AND ORDER_KIND_CODE_STR IN ('0502','0521','0522','0523','0524','0525','0526') AND NAME LIKE '%' || :B_NAME || '%' ORDER BY 2,1 ' in C:\Program Files\PHP\includes\Zend\Db\Statement\Oracle.php:244 Stack trace: #0 C:\Program Files\PHP\includes\Zend\Db\Statement.php(283): Zend_Db_Statement_Oracle->_execute(Array) #1 C:\Program Files\PHP\includes\Zend\Db\Adapter\Abstract.php(405): Zend_Db_Statement->execute(Array) #2 C:\Program Files\PHP\includes\Zend\Db\Adapter\Abstract.php(616): Zend_Db_Adapter_Abstract->query('???????SELECT??...', Array) #3 C:\php_eclipse\workspace\ShinryoShien\shinryo_shien\tools\sbs_db_access.php(68): Zend_Db_Adapter_Abstract->fetchAll('???????SELECT??...', Array) #4 C:\php_eclipse\workspace\ShinryoShien\shinryo_shien\models\item_search\is_master_model.php(2090): SBSDBAccess->fetchAll('???????SELECT??...', Array) #5 C:\php_eclipse\workspace\ShinryoShien\shinryo_shien\windows\select_common.php(355): IsMasterModel->getDocSetList('???Y?^') #6 {main} 2013-03-18 19:02:51 【 INFO】 SELECT SET_NO CODE ,'[' || SET_NO || ']'|| NAME || DECODE(SET_KIND,0,'(院内共通)',1,'('|| SECTION_NAME ||')',2,'('|| TARGET_UNAME ||')','') NAME FROM ORDER_SET WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = 1 AND ORDER_KIND_CODE_STR IN ('0502','0521','0522','0523','0524','0525','0526') AND NAME LIKE '%' || :B_NAME || '%' ORDER BY 2,1 2013-03-18 19:03:41 【 INFO】 SELECT SET_NO CODE ,'[' || SET_NO || '] '|| NAME || DECODE(SET_KIND,0,'(院内共通)',1,'('|| SECTION_NAME ||')',2,'('|| TARGET_UNAME ||')','') NAME FROM ORDER_SET WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = 1 AND ORDER_KIND_CODE_STR IN ('0502','0521','0522','0523','0524','0525','0526') AND NAME LIKE '%' || :B_NAME || '%' ORDER BY 1 2013-03-18 19:04:31 【 INFO】 SELECT SET_NO CODE ,'[' || SET_NO || '] '|| NAME || DECODE(SET_KIND,0,'(院内共通)',1,'('|| SECTION_NAME ||')',2,'('|| TARGET_UNAME ||')','') NAME FROM ORDER_SET WHERE CONDITION_FLG = :B_CONDITION_FLG AND LAST_FLG = 1 AND ORDER_KIND_CODE_STR IN ('0502','0521','0522','0523','0524','0525','0526') AND NAME LIKE '%' || :B_NAME || '%' ORDER BY 1