I am trying to call two Stored Procedures via Execute SQL Statement
calls.

The two calls work in SQL Developer but throw errors in Validator.

Here is the Validator Log of the first error. The test never gets to
the second call.

06/26/2015 16:36:58 INFO: ================================= TEST
=======================================
06/26/2015 16:36:58 INFO: Executing test: Retrieve a user from ESD
06/26/2015 16:36:58 INFO: -------------------------------- SETUP ACTION
--------------------------------
06/26/2015 16:36:58 INFO: ESD and EMNA DB: getJdbcValue() - SQL: select
PRSN_I from NETIQAPO.V_NETIQ_PRSN where PRSN_I_PBLC='P0010443';
06/26/2015 16:36:58 INFO: ESD and EMNA DB: getJdbcValue() - Setting
Variable: lvTest
06/26/2015 16:36:59 INFO: Executing sql statement: select PRSN_I from
NETIQAPO.V_NETIQ_PRSN where PRSN_I_PBLC='P0010443'
06/26/2015 16:36:59 INFO: Value found: 710023
06/26/2015 16:36:59 INFO: -------------------------------- SETUP ACTION
--------------------------------
06/26/2015 16:36:59 INFO: IDV: assertObjectNotExists() - targetFdn:
cn=P0010443,ou=Users,ou=Data,o=EmoryDev
06/26/2015 16:36:59 INFO: IDV: assertObjectNotExists() - PASSED
06/26/2015 16:36:59 INFO: -------------------------------- TEST ACTION
---------------------------------
06/26/2015 16:36:59 INFO: Event Security Bus (DB): executeSQL() - SQL:
call idmapo.p_rst_netiq( 710023 );


06/26/2015 16:37:00 INFO: Executing sql statement: call
idmapo.p_rst_netiq( 710023 )
06/26/2015 16:37:00 INFO: java.lang.AssertionError:
java.sql.SQLException: ORA-06576: not a valid function or procedure
name
while executing action method executeSQL
06/26/2015 16:37:00 INFO: *********** FAILING TEST Retrieve a user from
ESD - CONTINUE TO NEXT TEST ***********
06/26/2015 16:37:00 INFO: FAILED - Retrieve a user from ESD
06/26/2015 16:37:00 INFO:
06/26/2015 16:37:00 INFO:

Database is Oracle 11. Validator is using the latest ojdbc6.jar file.
We are using the same Database user in Validator as in SQL Developer.


--
tse7147
------------------------------------------------------------------------
tse7147's Profile: https://forums.netiq.com/member.php?userid=466
View this thread: https://forums.netiq.com/showthread.php?t=53775