How to call stored function in java?

[Raymond Ou]

Hi, I am writing a stored function "create or replace function show_itemcount return number"in oracle, I got error "show_itemcount is not stored procedure" error when called it in java using {call show_itemcount} and stmt.execute().
Should I use int nItemCount=stmt.executequery() instead?
Thank you,
Raymond

[Avi Abrami]

Raymond,
This is just a suggestion. Try:

{? = call show_itemcount}

Good Luck,
Avi.

[Raymond Ou]

Avi, Thanks a lot! The code runs fine.
Raymond