• 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
Sheriff
Posts: 36031
432
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?
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!