Re: how do i execute a stored procedure?

From: Thor <thor_at_echidna.net>
Date: Thu, 15 Oct 1998 10:12:16 -0700
Message-ID: <705l3s$l7k$1@news.bctel.net>

That looks like a function call ... can you post the definition, that would help allot, and where are you trying to call it from??

In SQL*Plus one of the many ways to do this is:

define my_property varchar2(30)

begin

:my_property := FIND_PROPERTY(BPHONE IN NUMBER); end;
/
print my_property

Thor HW

Pece Najdovski wrote in message ...
>I have a databases assignemnt where we have to implement a stored procedure
>FIND_PROPERTY(BPHONE IN NUMBER);
>
>I have the procedure in place but have problems executing it.
>Anyone know the correct command to execute a PL/SQL stored procedure?
>Peter.
>
Received on Thu Oct 15 1998 - 12:12:16 CDT