One thing i'wd like to add. The return type of the function is Char. So i registered the out Parameter as Types.CHAR. But for getting the value i user stmt.getString(1), will this wrk.
Yes it worked.. But still i cant understand the problem. Oracle returns a single Character. I got the value in this way, shiftId = stmt.getString(1); But in the console i saw that the value of shiftID is of length 255 in which the first character is the return value & the rest is padded with empty spaces, then i used the trim() method it's working. Any reason for this.