Hello.
In whole month, i search and
testing in many more way's for get this answered. The question is simple :
i just want to get from output parameter using Parameter OUT.
First of all:
1. Primefaces 4
2.
JSF 2.2
3. Oracle 11g
4. Eclipselink 2.5.2
My source :
oracle
----
---
----------first call this function.
-------------------
PegawaiFacade.java =======================
=======================
===========================
PegawaiFacadeRemote.java----------------------
.
---------------------------------------------------------
PegawaiProcedure.java ----------
-----
if i deploy above script the result is :
INFO: nama_table :VIEW_PENDIDIKAN_JENJANG
INFO: nomor :KKT900031
INFO: user :SDM
INFO: Parameter[position=4]
WARNING: Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.0.v20130507-3faac2b): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Invalid column index
Error Code: 17003
Call: BEGIN Refresh_Persoeis(nama_tabel=>?, in_nrk=>?, userupd=>?, tgmulai_out=>?); END;
bind => [7 parameters bound]
Query: ResultSetMappingQuery(name="PegawaiProsRefresh_Persoeis" )
Why this happen ? and how to build good script for get value from Oracle Procedure output parameter ?
Thank