Home » Server Options » Text & interMedia » Compilation when Login
Compilation when Login [message #76037] Mon, 21 April 2003 01:03 Go to next message
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
Messages: 110
Registered: February 2001
Senior Member
Create or replace trigger tname before logon on schema
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'))
EXECUTE IMMEDIAE 'ALTER ' || c1.otype || ' ' || c1.oname || ' Compile ';
end loop;
Previous Topic: DRG-10200: invalid server personality mask: QDM
Next Topic: How do i know Table Dependencies
Goto Forum:

Current Time: Wed Aug 23 20:20:08 CDT 2017

Total time taken to generate the page: 0.05009 seconds