wood burning stoves 2.0*
The moose likes JDBC and the fly likes calling stored function Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "calling stored function" Watch "calling stored function" New topic
Author

calling stored function

sinasi susam
Ranch Hand

Joined: Jul 15, 2005
Posts: 67
Hi,

I will ask for help ,how to call a stored function.I searched internet and read about some topics in forum too.But i could not manage.

I have a function in oracle db but i couldn't manage to call it.
I did all what they said for calling stored function but it didn't work!!!
My mood has been crashed.
I am about to cry.pls help.
sinasi susam
Ranch Hand

Joined: Jul 15, 2005
Posts: 67
Sorry i forgot to write my code;
can you please check it?
my procedure head is ;



And the error is like;
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42263
    
  64
And which one is line 31 in which the error occurs?


Ping & DNS - my free Android networking tools app
praveen kanakarajan
Ranch Hand

Joined: Apr 27, 2005
Posts: 54
pls do give a visit .hope it will be helpful for you
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:22831699179048
sinasi susam
Ranch Hand

Joined: Jul 15, 2005
Posts: 67
cstmt.registerOutParameter(1,Types.BOOLEAN);

it is.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: calling stored function