newbie oracle question?

[Shawn]

CREATE OR REPLACE FUNCTION getThreadCount RETURN NUMBER AS BEGIN
SELECT COUNT(*) INTO counter FROM thread;
RETURN counts;
END;
/

this function compiles, oracle accepts its. I'm not able to execute it ... exec getThreadCount returns an error stating I'm missing an arguement. I tried this block below and it didn't work either.

BEGIN
DECLARE X NUMBER
EXEC GETTHREADCOUNT(X)
END;
/

Any advice? Oracle's guide and googling for a couple hours now and I'm coming up short.
but "exec getThreadCount" and "exec getThreadCount()" say I'm missing arguments

 

[Kasey C]

Your function declaration is wrong (for the call you make to it later)

You did not define it to accept any variables, yet you are calling it with X later.

basically, oracle says "X? What the heck is X? This function doesn't need X?"

---
Kasey C, PC guru since Apple II days
Lottery: A tax on people who are bad at math.