Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    bangalore
    Posts
    14

    Unanswered: Invalidating the dependent procedures..

    Hi,

    We have a package, which generates procedures dynamically depending on the user input and these newly generated procedures are used by some other package. Whenever this new generation of procedures happens, my dependent package is becoming invalid and is not able to use this. To use it all I need to do is just recompile the procedure. Is there anyway where in I force Oracle try to compile invalid procedures when there is a call to procedure and throw the error only if it is invalid still?

    Murali
    Murali Mohan Rao. M

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Invalidating the dependent procedures..

    If you use packaged procedures, then provided you only change the package body, dependent objects will not become invalid.

    But generating, compiling and using stored procedures at run time is a strange and dubious practice. Is there not another way?

  3. #3
    Join Date
    Jan 2004
    Location
    bangalore
    Posts
    14
    Here we are giving a free hand to the user to create his own conditions and creating formulae. To enable this feature we need to necessarily create procedures dynamically depending upon the user input.

    Murali
    Murali Mohan Rao. M

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    If those procedures could vary in name and/or parameter lists, then you couldn't call them statically from existing procedures anyway - so presumably the names and parameter lists are fixed? If so, wrapping them in a package will solve your problem.

Posting Permissions

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