Win a copy of Succeeding with AI this week in the Artificial Intelligence and Machine Learning forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
  • Junilu Lacar
Sheriffs:
  • Tim Cooke
  • Jeanne Boyarsky
  • Knute Snortum
Saloon Keepers:
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
  • Piet Souris
Bartenders:
  • salvin francis
  • fred rosenberger
  • Frits Walraven

sql statement executes in Toad, not in app

 
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;
 
author & internet detective
Posts: 39959
804
Eclipse IDE VI Editor Java
  • 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.
 
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?
 
Crusading Chameleon likes the size of this ad:
Two software engineers solve most of the world's problems in one K&R sized book
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic