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/Doctor_Model.php
Line: 90
Function: query

File: /home/suction/public_html/application/controllers/365mc/Intro.php
Line: 595
Function: doctorScheduleListPerson

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/Doctor_Model.php
Line: 90
Function: query

File: /home/suction/public_html/application/controllers/365mc/Intro.php
Line: 595
Function: doctorScheduleListPerson

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='jwju' order by Z.SETDATE, Z.SETTIME

Filename: models/Doctor_Model.php

Line Number: 90