how to save a stored procedure ?

[Raj Ohadi]

I use 10g XE. I use its "SQL script" tool and create store procedure/functiona called "TEST" and clicked "save".

Then I wrote simple jdbc callable statement to try to call that function, but I got error --

ORA 06550 -- HR.TEST is invalid.

It seems it can not find that store procedure ? WHy ? Is the store proceures supposed to be saved in oraexe/oradata/XE/ directory ?? I even tried mannually put that SQL in that directory but it didn't help either.

Confused.

[Raj Ohadi]

Have figured it out. Thanks Guys.