title: PL/SQL exception and Java programs
body: <p>Business logic is coded in pl/sql packages procedures and functions.
  Java programs call pl/sql packages procedures and functions to do database work.</p>
  
  <p>pl/sql programs store exceptions into Oracle tables whenever an exception is raised.</p>
  
  <p>How would my java programs get the exceptions since the exception instead of being propagated from pl/sql to java is getting persisted to a oracle table and the procs/functions just return 1 or 0.</p>
  
  <p>Sorry folks i should have added this constraint much earlier and avoided this confusion. As with many legacy projects we don't have the freedom to modify the stored procedures.</p>