| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: how do i execute a stored procedure?
Pece Najdovski wrote
>I have a databases assignemnt where we have to implement a stored
procedure
>FIND_PROPERTY(BPHONE IN NUMBER);
It seems to me that this should return some value? Then it should be a
stored function, not a procedure. Show us the code, please!
>Anyone know the correct command to execute a PL/SQL stored procedure?
In SQL*Plus:
begin
FIND_PROPERTY(1234);
end;
/
or simply
exec FIND_PROPERTY(1234)
Arjan. Received on Thu Oct 15 1998 - 00:15:18 CDT
 |
 |