how to run the stored procedure
Hi Again,
I've created the procedure to update statistics but now I'm not sure how
to run it. The procedure is really simple :
create procedure updstats()
update statistics high for table table_name;
end procedure;
The question now is 1) How do I run the procedure and 2) How do I give
privileges to another user.
If the procedure was returning something then I wouldn't be asking question
1, but simplicity kills :-)
Thanx a lot
Austin
In article <807p31$a98$1@news.xmission.com>,
Austin Castro <acastro@btl.net> wrote:
>
> Hi Again,
> I've created the procedure to update statistics but now I'm not
sure how
> to run it. The procedure is really simple :
>
> create procedure updstats()>
> update statistics high for table table_name;>
> end procedure;
>
> The question now is 1) How do I run the procedure and 2) How do I give
> privileges to another user.
>
> If the procedure was returning something then I wouldn't be asking
question
> 1, but simplicity kills :-)
>
>
Thanx a
lot
>
Austin
>
?
execute procedure updstats()
I don't understand the 'if the procedure was returning something...'
statement. Is that making a difference for some reason? I created the
same procedure just to test with and didn't have any problems.
--
# unrm /
ksh: unrm: not found
# man cpio
Sent via Deja.com http://www.deja.com/
Before you buy.