Home » Server Options » Text & interMedia » Compilation when Login
Compilation when Login [message #76037] Mon, 21 April 2003 01:03 Go to next message
Joe
Messages: 138
Registered: November 1999
Senior Member
How do i compile all the procedures/ function when login.
Re: Compilation when Login [message #76039 is a reply to message #76037] Mon, 21 April 2003 22:41 Go to previous message
Venkat
Messages: 110
Registered: February 2001
Senior Member
Create or replace trigger tname before logon on schema
begin
for c in (select object_name oname, object_type otype from user_objects where status = 'INVALID' and (object_type LIKE '%PACKAGE%' or object_type='PROCEDURE' or object_type = 'PACKAGE'))
LOOP
EXECUTE IMMEDIAE 'ALTER ' || c1.otype || ' ' || c1.oname || ' Compile ';
end loop;
end;
Previous Topic: DRG-10200: invalid server personality mask: QDM
Next Topic: How do i know Table Dependencies
Goto Forum:
  


Current Time: Thu Mar 28 16:58:28 CDT 2024