Проблема проверки выполнения хранимой процедуры с использованием JPA ⇐ JAVA

[Anonymous]

Hi I am executing a stored procedure which is executing perfectly fine however following line is returning false storedProcedureQuery.execute() Please guide if I am doing something wrong else please guide me if there is some other way to ensure if execution of stored procedure was successful ?

Below is my stored procedure for reference:
StoredProcedureQuery storedProcedureQuery = getEm().createStoredProcedureQuery( IntegrationsConstants.Database.LEGACY_SCHEMA_NAME + ".LEGACY_STATUS_UPDATE"); // Registering procedure params storedProcedureQuery.registerStoredProcedureParameter("arg_REFERENCE_NO", String.class, ParameterMode.IN); storedProcedureQuery.registerStoredProcedureParameter("arg_BRANCH_CODE", String.class, ParameterMode.IN); storedProcedureQuery.registerStoredProcedureParameter("arg_JOURNAL_CATEGORY", String.class, ParameterMode.IN); storedProcedureQuery.setParameter("arg_REFERENCE_NO", accountingEntryLegacyJournal.getReferenceNo()); storedProcedureQuery.setParameter("arg_BRANCH_CODE", accountingEntryLegacyJournal.getBranchCode()); storedProcedureQuery.setParameter("arg_JOURNAL_CATEGORY", accountingEntryLegacyJournal.getJournalCategory()); boolean result = storedProcedureQuery.execute(); IntegrationsUtils.logMessage(Level.INFO, "Proc is " + result);

Источник: https://stackoverflow.com/questions/781 ... -using-jpa