| ( ! ) Warning: ociexecute(): ORA-00936: 누락된 표현식 in /data/june/worldtee/mobile_v2/libs/class_oracle.php on line 145 |
|---|
| Call Stack |
|---|
| # | Time | Memory | Function | Location |
|---|
| 1 | 0.0004 | 262096 | {main}( ) | .../tourlist.php:0 |
| 2 | 0.3084 | 2895904 | TQuery->rows( ) | .../tourlist.php:127 |
| 3 | 0.3084 | 2895952 | TQuery->getRows( ) | .../class_oracle.php:162 |
| 4 | 0.3085 | 2897960 | ociexecute
( ) | .../class_oracle.php:145 |
Page: /surf/tourlist.php
Query:
select distinct b.country_no, nvl(decode(':lang','KR',h.name,i.name),h.name) as country_name
from surf_tour a left join surf_user b on a.no_user = b.no
left join code h on h.no = b.country_no
left join code_lang i on i.no=h.no and i.lang=:lang
where nvl(country_no,0) > 10000
and a.cd_city =
order by country_name