Yeh!! somebody help ma ya.In the callable statement I used 7 IN parameter and 1 OUT parameter.I can't get the OUT parameter value.But without IN parameter it is working.I used Oracle Stored Procedures for this. Pls somebody help me .I'm totally confused by this.
Hi Rajesh Nothing wrong with your java code.I think something wrong with your storedprocedure.You have declared the varialble in Stored procedure as 'ProdName VarChar2', is that correct? .please check your Oracle stored procedure. Vinay
Hi vinay!! It works fine in oracle.By using another procedure I called that one and receive the return value.I'm using oracle8 and JDK1.3 in windows 95.Is there is any problem by this. Thankx for replying me chandran
I see some of your in parms are set to number and not integer. Try changing all the proc parms to integer and see if it works. A integer is supposed to be like a number, but with the driver maybe not. Remember that a number can have decimal places, not an integer. So I would give it a try. Dan
Hi Dani!! Thankx.Still I'm getting the same Error.I'm using oracle8 JDK1.3 and windows 95.I don't know where I'm going wrong.Shall I try using Oracle8i instead of Oracle8.I think Oracle8 supports JDK 1.0 and Oracle 8i supports JDK1.2.Am I correct or not. chandran..
Hi Chandran, While running your java program can you look into the Oracle database LOg.so that i can know what is goinng on In the Oracle database.I strongly feel that something wrong with your stored procedure.you can use oracle8 and JDK1.3 in windows 95.
I got it.Nothing wrong in my StoredProcedure.Only Version is problem.Only Oracle8i sends the OUT parameter to Java.We can pass values through other version.But Only Oracle8i allows U to get the OUT parameter.