FilesExpand file tree

master

/

sqlplus_return_code_2.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

49 lines (34 loc) · 716 Bytes

master

/

sqlplus_return_code_2.sql

Copy path

Top

File metadata and controls

• Code
• Blame

49 lines (34 loc) · 716 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

36

37

38

39

40

41

42

43

44

45

46

47

-- sqlplus_return_code_2.sql

-- test if a+b = c

-- exit if test fails

create or replace function errchk ( test_number_in varchar2 ) return integer

is

v_number integer;

begin

v_number := to_number(test_number_in);

return 1;

exception

when invalid_number or value_error then

raise_application_error(-20100,'Your Error Message Here' );

end;

/

define a=1

define b=2

define c=3

-- it is important to exit to the shell with an

-- error code so that the controlling process

-- knows an error occurred

whenever sqlerror exit 1

select decode( sign( (&a+&b) - &c) ,

0,errchk(0),

errchk('failed')

)

from dual

/

define c=2

select decode( sign( (&a+&b) - &c) ,

0,errchk(0),

errchk('failed')

)

from dual

/