Re: Procedure execution in ORACLE7

Ivan MIngot Latorre (mingot_at_llevant.uji.es) wrote:

> I´m working in hp 9887/hp-ux 9.0 and before migrate from
> ORACLE v6.36 to ORACLE7 i´m doing some proves on ORACLE7.
 

> I have a question, Can I execute a function (or a procedure
> with OUTs parameters) directly from the prompt of SQL.
> In afirmative case, please tell me how.

Yes, You can execute any stored procedure from SQL*Plus.

        SQL> exec anyStoredProcedure
In the case of parameter, the bind variables need to be declared before you execute the stored procedure.

        SQL> var myVariable [number|char[n]...] Bind variables are treated as of calling from any Pro compilers

        SQL> exec aStoredProcedure( :outParameter ) You can check the value of outParameter by

        SQL> display outParameter
    or SQL> select :outParameter from dual;

> Thanks.

Khiem Luc
temp. email: khiem_at_gftpd-mail.citicorp.com Received on Thu Jan 20 1994 - 20:09:50 CET