• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

sql statement executes in Toad, not in app

 
td ward
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Ranchers
I have a statement that executes in Toad but will not execute in my app using an Oracle JDBC driver - any ideas?
SELECT view1.hr_clnt_id_stub,view1.hr_pmnt_id_stub,view1.hr_pmnt_dt,view1.hr_pmnt_num,view1.hr_tot_net_amt,view1.hr_seq_origin_abbr,view1.hr_pmnt_mthd_cd,view2.hr_can_chk_dt from view1,view2 where R_PMNT_STUB_VW.hr_ssn_stub = 221941863 and view1.hr_clnt_id_stub=view2.HR_CLNT_ID_CANCHK(+) and view1.hr_pmnt_id_stub=view2.HR_PMNT_ID_CANCHK(+) order by view1.hr_pmnt_dt desc;
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Not clear on how this executes in Toad. Part of your query has:

But R_PMNT_STUB_VW is neither view1 nor view 2.
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
what are the details of the SQLException?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic