-
Notifications
You must be signed in to change notification settings - Fork 0
/
name.sql
36 lines (24 loc) · 820 Bytes
/
name.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
--------------------------------------------------------
-- File created - Wednesday-July-27-2022
--------------------------------------------------------
--------------------------------------------------------
-- DDL for Procedure TEST_CI_CD
--------------------------------------------------------
set define off;
CREATE OR REPLACE EDITIONABLE PROCEDURE "GPC"."TEST_CI_CD" AS
cursor csr_test is
select name,TABLECHANGED from CX_TEST_CICD_SCRIPT;
BEGIN
FOR csr_test_v IN csr_test LOOP
begin
update CX_TEST_CICD_SCRIPT
set name = CONCAT(name, '_changed')
where TABLECHANGED = 'changed';
EXCEPTION when OTHERS then
raise_application_error(-20010,'Error');
end;
end LOOP;
commit;
END TEST_CI_CD;
/*comment */
/