Problem with IN parameters to an Oracle stored procedure

Hello all

I had earlier posted the same problem I am having on
comp.java.lang.programmer earlier and someone suggested this post
would probably fall better under this group. Here is the link to the
original post with the original post copy pasted below.

http://groups.google.co.in/group/comp.lang.java.programmer/browse_thread/thread/b0b845981c3e403a/#

Since then I have changed the IN parameter to my stored procedure to
read as

clID IN TABLEA.CLIENTID%TYPE

instead of clientID, based on a suggestion to the earlier post and
have still had no luck.

Any suggestions are welcome.

Thanks
Swetha