Home » SQL & PL/SQL » SQL & PL/SQL » Recompile everything using a view?
Recompile everything using a view? [message #854] Fri, 08 March 2002 08:11 Go to next message
cath
Messages: 4
Registered: March 2002
Junior Member
Hi

Would someone be able to tell me if I would need to recompile everything(packages,procedures,functions) that uses a view if I change the view?

thnx
Re: Recompile everything using a view? [message #855 is a reply to message #854] Fri, 08 March 2002 08:15 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
if new changes to view affects any stored program, you should compile. (it means, for example if you are using select * from view_name etc in your program)
Previous Topic: define editor command
Next Topic: Sql
Goto Forum:
  


Current Time: Fri Mar 29 07:51:07 CDT 2024