/hippo-schema/procedures/sp_update_version.sql

http://hdbc.googlecode.com/ · SQL · 8 lines · 8 code · 0 blank · 0 comment · 0 complexity · 1738c2806f14d352cee742d2e26dbaaf MD5 · raw file 

    

  1. CREATE OR REPLACE PROCEDURE sp_update_version

    2. 

  2. (

    3. 

  3.     version_no IN NUMBER

    4. 

  4. ) AS

    5. 

  5. BEGIN

    6. 

  6.   UPDATE version SET version = version_no;

    7. 

  7. END;

    8. 

  8. /
    9.