Silent stored procedure
I have a stored procedure that aggregates information from one table into another table.
Initially the procedure sets a variable by doing a SELECT (select @maxId:=max(idLocalization) from localization;).
When I do "call myprocedure()" from the Query Browser I get an output for the @maxId as a resultset.
I have a process (.Net) that calls this procedure frequently. Will this resultset cause any memory issues? Is there a way to suppress the resultset to make the procedure silent?
Subject
Views
Written By
Posted
Silent stored procedure
3064
December 16, 2005 03:43AM
2612
December 16, 2005 03:56AM
1545
December 16, 2005 04:14AM
1658
December 16, 2005 04:24AM
1501
December 16, 2005 04:14AM
1920
December 16, 2005 04:19AM
1546
December 16, 2005 06:17AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.