Severity: Warning
Message: oci_execute() [function.oci-execute]: ORA-01427: single-row subquery returns more than one row
Filename: oci8/oci8_driver.php
Line Number: 286
Backtrace:
File: /home/suction/public_html/application/models/Doctor_Model.php
Line: 39
Function: query
File: /home/suction/public_html/application/controllers/365mc/Intro.php
Line: 341
Function: doctorScheduleList
File: /home/suction/public_html/index.php
Line: 327
Function: require_once
Severity: Warning
Message: Cannot modify header information - headers already sent by (output started at /home/suction/public_html/system/core/Exceptions.php:272)
Filename: core/Common.php
Line Number: 573
Backtrace:
File: /home/suction/public_html/application/models/Doctor_Model.php
Line: 39
Function: query
File: /home/suction/public_html/application/controllers/365mc/Intro.php
Line: 341
Function: doctorScheduleList
File: /home/suction/public_html/index.php
Line: 327
Function: require_once
Error Number: 1427
ORA-01427: single-row subquery returns more than one row
SELECT Z.SETTIME , Z.SETDATE , Z.USERID , (SELECT BAS_SUBIDEN FROM BAS010T WHERE BAS_CODE = '913' AND BAS_SETCODE = Z.GUBUN) AS GUBUN , (SELECT DECODE(ENVPATH,'','','휴일') FROM SYS000T WHERE ENVBRAN = 'A' AND ENVUSER = Z.STARTBRAN AND (ENVIDEN = substr(Z.SETDATE,1,8) OR ENVIDEN = substr(Z.SETDATE,5,8)) AND Z.SETDATE!='20171003') HOLIDAY , (SELECT HL_KNAME FROM BAS080T WHERE HL_DATE = substr(Z.SETDATE,1,8) ) HOLIDAY2 From BAS210T Z Where 1 = 1 AND USERID in ('pingwa','minz','sh','04lsy','med07','psdr','lhj','jwju','JJM365') AND STARTBRAN = '36' AND ( SETDATE BETWEEN '20260810' AND '20260815' OR SETDATE BETWEEN '20260817' AND '20260822' ) -- And substr(SETDATE,1,6) = '201702' --일자 -- And USERID IN () --닥터아이디 And Z.CANCEL = 'N' --취소여부 order by Z.SETDATE, Z.SETTIME
Filename: models/Doctor_Model.php
Line Number: 39