Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

calling stored function

 
sinasi susam
Ranch Hand
Posts: 67
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 67
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sorry i forgot to write my code;
can you please check it?
my procedure head is ;



And the error is like;
 
Ulf Dittmer
Rancher
Pie
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
And which one is line 31 in which the error occurs?
 
praveen kanakarajan
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 67
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
cstmt.registerOutParameter(1,Types.BOOLEAN);

it is.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic