Re: call a stored procedure
From: Morten <morten_at_kikobu.com>
Date: Wed, 20 Feb 2002 16:37:13 +0100
Message-ID: <3C73C2A9.2060304_at_kikobu.com>
Date: Wed, 20 Feb 2002 16:37:13 +0100
Message-ID: <3C73C2A9.2060304_at_kikobu.com>
Fleury Marcel wrote:
> Hello,
> I would like to know if it is possible to call a stored procedure from
> tool like Sql*Plus ?
> Or is it only possible trough an application ?
>
> The goal is to prevent users that can directly access a DB using tools
> to run stored procedures.
>
SQL> CREATE OR REPLACE PROCEDURE helloWorld AS
BEGIN
DBMS_OUTPUT.ENABLE(1000000);
DBMS_OUTPUT.PUT_LINE('Hello world!');
END;
/
2 3 4 5 6
Procedure created.
SQL> SET serveroutput ON
SQL> exec helloWorld
Hello world!
PL/SQL procedure successfully completed. Received on Wed Feb 20 2002 - 16:37:13 CET