PageRenderTime 36ms CodeModel.GetById 29ms app.highlight 3ms RepoModel.GetById 1ms app.codeStats 0ms

/hippo-migrate/templates/do/00004-do_sp_update_version.sql

http://hdbc.googlecode.com/
SQL | 12 lines | 10 code | 2 blank | 0 comment | 0 complexity | a60f2afde1a261a9e8657444fce226fa MD5 | raw file
 1
 2CREATE OR REPLACE PROCEDURE ${schema}.sp_update_version
 3(
 4    version_no IN NUMBER
 5) AS
 6BEGIN
 7  UPDATE version SET version = version_no;
 8END;
 9/
10
11UPDATE ${schema}.version SET version = 4;
12COMMIT;