Home » RDBMS Server » Server Administration » Re: how to Keep single function in the share pool?
Re: how to Keep single function in the share pool? [message #370503] Wed, 08 December 1999 16:47
hmg
Messages: 40
Registered: March 1999
Member
In Oracle 8.0.5 this works

create or replace function getdate
return date
is
   v_date   date;
begin
   select sysdate into v_date from dual;
   
   return (v_date);
end;
/

begin
   dbms_shared_pool.keep('getdate');
end;
/
PL/SQL procedure successfully completed.

But I don't know what about version 7.3.

Report message to a moderator

Previous Topic: I need an PL/SQL algorithm to handle combination searching
Next Topic: Oracle 8 export file in Oracle 7
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Aug 15 02:21:53 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.