SQL & PL/SQL

Hello,

I am getting following exception while calling stored produre:

*"Ordinal binding and Named binding cannot be combined"*

I am calling stored procedure with JDBC with 1 input parameter and 1 output parameters as mentioned below:

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

CallableStatement collableStat = connection.prepareCall("{ call sp_clnt_intermed_validation(?,?) };

// Registering In parameters
collableStat.setString("p_user_name", "SampleUser");

// Registering Out parameters

for(String paramKey : paramKeysSet) {
collableStat.registerOutParameter("p_success_flag", Types.VARCHAR);
}

// execute stored procedure
collableStat.execute();
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Please guide.

Regards,
Akshay.

Edited by: 914678 on Feb 15, 2012 5:48 AM