Skip to content

Instantly share code, notes, and snippets.

@caleywoods
Created August 7, 2015 18:46
Show Gist options
  • Save caleywoods/c4aed3a532c7b261cdff to your computer and use it in GitHub Desktop.
Save caleywoods/c4aed3a532c7b261cdff to your computer and use it in GitHub Desktop.
QueryException in Connection.php line 624:
Error Code : 936
Error Message : ORA-00936: missing expression
Position : 497
Statement : select * from commission.commission_activity_detail where (select count(*) from commission.commission_activity where commission.commission_activity_detail.commission_activity_id = commission.commission_activity.commission_activity_id and (select count(*) from commission.interface_type where commission.interface_type.type_id = commission.commission_activity.interface_type_id and interface_type_id = :autoparam0 and extract(month from commission.commission_activity_detail.created_date) = ' or '1'='1) >= 1) >= 1 and pushed_to_holding_flag = :autoparam1
Bindings : [3,0]
(SQL: select * from commission.commission_activity_detail where (select count(*) from commission.commission_activity where commission.commission_activity_detail.commission_activity_id = commission.commission_activity.commission_activity_id and (select count(*) from commission.interface_type where commission.interface_type.type_id = commission.commission_activity.interface_type_id and interface_type_id = 3 and extract(month from commission.commission_activity_detail.created_date) = ' or '1'='1) >= 1) >= 1 and pushed_to_holding_flag = 0)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment