Re: Use Function & Procedure

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Tue, 18 Dec 2001 18:11:01 GMT
Message-ID: <3c1f85f0.2518905718@news.alt.net>

On Tue, 18 Dec 2001 16:39:12 GMT, "Flex" <flexNOSP_at_Mfreemail.it> wrote:

>
>"Giuseppe" <fioritoNOSPAM_at_libero.it> ha scritto nel messaggio >
>> SELECT function(arg, ...) FROM dual;
>>
>System said that Function not in memory or into a DB
>> EXECUTE procedure(arg, ...);
>>
>
>

Try this:

CREATE PROCEDURE TEST AS BEGIN NULL; END; /

You should see:

<<
Procedure created.
<<

Then try:

EXECUTE TEST You should see:

<<
PL/SQL procedure successfully completed. <<

If you do not, tell us what you do see.

Also, if the user who created the procedure is different than the user who is to run it, or the user who created it has created it in a different schema:

GRANT EXECUTE ON TEST TO User;

Brian Received on Tue Dec 18 2001 - 12:11:01 CST