Answered Questions

  • May 26 2010
    03:17 AM
    5904
    18

    Status of Procedure
    • anulc

    If a procedure is referring a table and if the structure of the table is changed, lets say data type of the any column is changed, then is it possible that the status of the procedure remains valid? Explain

    Star Read Best Answer

    Editorial / Best Answer

    tar.goyal  

    • Member Since Aug-2010 | Aug 4th, 2010

    It is possible that a procedure remain valid even when the data type of columns of a table on which it is operating change.


    This can be achieved by using Anchor declaration i.e. %TYPE and %ROWTYPE while defining reference to such table columns and rows respectively in the procedure.

    tar.goyal

    • Aug 4th, 2010

    It is possible that a procedure remain valid even when the data type of columns of a table on which it is operating change.This can be achieved by using Anchor declaration i.e. %TYPE and %ROWTYPE while defining reference to such table columns and rows respectively in the procedure.

    anironic

    • Jul 21st, 2010

    If PL/SQL stored SP %type and does not explicity declare a datatype, then it is quite possible that Stored procedure remains valid, even after changing the datatype in the table. Ex, you have a declar...