2016-01-08 10:08 GMT+01:00 Sachin Srivastava <ssr.teleat...@gmail.com>:
> Hi, > > I am also getting "syntax error for below function (just some lines of > function where I am getting syntax error), please suggest why? > Using Oracle's outer join syntax, not ANSI SQL syntax Regards Pavel > -------------------- > > -- Image path > AND mk1.subscriber_id(+)=pcat_catalog_item.subscriber_id > AND cs1.subscriber_id(+)=pcat_catalog_item.subscriber_id > AND cs1.company_id(+)=pcat_catalog_item.company_id > AND > pcat_catalog_dup_detail.dest_subscriber_id(+)=pcat_item_categorization.subscriber_id > AND > pcat_catalog_dup_detail.dest_supplier_company_id(+)=pcat_item_categorization.item_company_id > AND > pcat_catalog_dup_detail.dest_catalog_code(+)=pcat_item_categorization.catalog_code > AND mk2.subscriber_id(+)=pcat_catalog_dup_detail.subscriber_id > AND cs2.subscriber_id(+)=pcat_catalog_dup_detail.subscriber_id > AND cs2.company_id(+)=pcat_catalog_dup_detail.company_id; > > -------------------------- > > > ERROR: syntax error at or near ")" > LINE 216: AND mk1.subscriber_id(+)=pcat_catalog_item.subscribe... > ^ > ********** Error ********** > ERROR: syntax error at or near ")" > SQL state: 42601 > Character: 10018 > > Regards > SS > >
