Home » SQL & PL/SQL » SQL & PL/SQL » procedure
procedure [message #245424] Sun, 17 June 2007 00:42 Go to next message
mkumar26
Messages: 3
Registered: June 2007
Junior Member
hi,

i have a procedure ..........that shows user_objects invalid(procedure)....


how can i valid that procedure.......



my solution is.....


if i create a new procedure means rectify if that procedure have
any errors so that procedure got validated....


2)suppose that procedure old means previoulsy it is validated....nw it shows invalid....hw can i solve ......


Re: procedure [message #245429 is a reply to message #245424] Sun, 17 June 2007 01:49 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> alter procedure ... compile;
SQL> show errors
Fix the errors
SQL> create or replace procedure ... <new code>

Regards
Michel
Previous Topic: delete with variables
Next Topic: Create view from the result of a function which returns ref cursor
Goto Forum:
  


Current Time: Fri Dec 09 23:18:08 CST 2016

Total time taken to generate the page: 0.08760 seconds