Re: call a stored procedure

From: Morten <morten_at_kikobu.com>
Date: Wed, 20 Feb 2002 16:37:13 +0100
Message-ID: <3C73C2A9.2060304@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 - 09:37:13 CST