Home » SQL & PL/SQL » SQL & PL/SQL » How to recompile package second time
How to recompile package second time [message #262208] Sat, 25 August 2007 01:57 Go to next message
raja_grk
Messages: 5
Registered: August 2007
Junior Member
Hi

How to recompile package second time?


Thanks
Raja
Re: How to recompile package second time [message #262210 is a reply to message #262208] Sat, 25 August 2007 02:08 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,

use the alter command.


regards,
Re: How to recompile package second time [message #262228 is a reply to message #262208] Sat, 25 August 2007 08:09 Go to previous message
beesetty
Messages: 3
Registered: December 1999
Location: Singapore
Junior Member

alter package <package Name> compile; -- to compile package
alter package <package name> compile body; -- to compile package body
Previous Topic: how to add new procedures to existing package
Next Topic: Help needed to solve this sql
Goto Forum:
  


Current Time: Sat Dec 03 13:54:48 CST 2016

Total time taken to generate the page: 0.09727 seconds