SEARCH: Error while evaluating SQL:
select dgc.content_type_cd,
dgc.source,
cma.content_type_name,
dgca.content_id,
dgca.title,
NVL(dgca.summary,dgca.short_summary) summary,
TO_CHAR(dgc.source_date, 'DD Mon YYYY') as source_date,
TO_CHAR(dgca.publish_date, 'DD Mon YYYY') as publish_date,
dgca.editor
from dg_guide_content_a dgca, dg_content dgc, cma_content_type cma
where
and dgca.digital_guide_id in (9,5)
and dgca.content_id = dgc.content_id
and dgc.content_type_cd = cma.content_type_cd
Database error: SQL call failed.
Error num : 5
VendorError1 : 936
VendorMessage1:
VendorError2 : 1
VendorMessage2: ORA-00936: missing expression