Re: PL/SQL Question

[Quoted] I read the replies that said you can only call a function. If so, please explain to me what is happening internally when I do something like the following many times a day from the SQL*PLUS command line (U actually use internal procedures to handle the dbms_output stuff):

set serveroutput on;
var v_rc number;
var v_return_string vchar2(25);

begin

       pr_get_state_text_name('TX', :v_return_string, :v_rc); end;

print v_rc;

'Texas'

Amoda Kulkarni <amodk_at_bellsouth.net> wrote:

>I want to know how to call a PL/SQL stored procedure from a SQL
>statement.
>
>Thanks in advance
>Amod Kulkarni
>email: amodk_at_juno.com
Received on Sat Jan 10 1998 - 00:00:00 CET