A PHP Error was encountered

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/CustomDoctor_Model.php
Line: 229
Function: query

File: /home/suction/public_html/application/controllers/365mc/DoctorIntro.php
Line: 525
Function: doctorScheduleListPerson

File: /home/suction/public_html/application/controllers/365mc/DoctorIntro.php
Line: 183
Function: getDoctorSchedule

File: /home/suction/public_html/index.php
Line: 327
Function: require_once

A PHP Error was encountered

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/CustomDoctor_Model.php
Line: 229
Function: query

File: /home/suction/public_html/application/controllers/365mc/DoctorIntro.php
Line: 525
Function: doctorScheduleListPerson

File: /home/suction/public_html/application/controllers/365mc/DoctorIntro.php
Line: 183
Function: getDoctorSchedule

File: /home/suction/public_html/index.php
Line: 327
Function: require_once

A Database Error Occurred

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 Z.CANCEL = 'N' --취소여부 AND SETDATE>='20250501' AND SETDATE<'20250701' AND USERID='pingwa' ORDER BY Z.SETDATE, Z.SETTIME

Filename: models/CustomDoctor_Model.php

Line Number: 229