Chris
You wrote I just want to call it and get the one value it returns.
I think that procedure does not return values, functions does.
If you want to get value from a procedure you have to pass
a parameter that the procedure will return the value in.
Yechiel Adar
Mehish
- Original Message
I started to get the feeling that since no one had the answer to my
question, maybe I was asking the wrong question.
Thanks to those who replied. You helped me figure out where I made a few
wrong assumptions.
I don't mess with procedures and functions much. A book I was using as a
reference
PROTECTED]
Subject: RE: calling a stored procedure from a sitescope monitor
Date: Tue, 21 May 2002 14:42:45 +1000
Chris,
I don't know what Sitescope is and I haven't used JDBC but can perhaps
offer a suggestion.
You say foo doesn't have any arguments and that it returns a value.
I take it that foo
in the monitor, and it runs, but I want to keep at it until I can call
procedures too.
BTW, desc bar returns
FUNCTION bar RETURNS NUMBER
-Chris
From: Reardon, Bruce (CALBBAY) [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: RE: calling a stored procedure from a sitescope monitor