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.

Report message to a moderator

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;

Report message to a moderator

Previous Topic: DRG-10200: invalid server personality mask: QDM
Next Topic: How do i know Table Dependencies
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Oct 12 12:11:20 CDT 2026
.:: Forum Home :: Wiki Home :: Contact :: Privacy ::.