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.
Previous Topic: I need an PL/SQL algorithm to handle combination searching
Next Topic: Oracle 8 export file in Oracle 7
Goto Forum:
  


Current Time: Fri Mar 29 03:11:42 CDT 2024