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: Tue May 21 02:07:14 CDT 2013

Total time taken to generate the page: 0.14576 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.