DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Store procedure problem

  1. #1
    Join Date
    Jun 2000
    Location
    Toronto, ON, Canada
    Posts
    50
    I have a package which contains a procedure named proc_replicate. The package is compiled with no errors, but when I try to execute the procedure it says that is INVALID. Indeed, if I check in user_objects table the status of this particular procedure is invalid. What could be the cause?

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    At the end of the package add "show errors; " then recompile it and see what happens. Once you are through, then try the executing the package on the sqlprompt and see the errors. It could be some exception and etc.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width