oracle存储过程,求指导

Question

-- 3 判断语句
-- IF 比较式 THEN BEGIN END; END IF;
CREATE OR REPLACE PROCEDURE test(x IN NUMBER)
IS
  BEGIN
    IF x > 0
    THEN
      BEGIN
        x := 0 - x;
      END;
    END IF;
    IF x = 0
    THEN
      BEGIN
        x := 1;
      END;
    END IF;
  END test;

[2017-03-21 15:48:19] [99999][17110] Warning: 执行完毕, 但带有警告

[2017-03-21 15:48:19] completed in 8ms

Answer 1

存储过程需要有输入和输出的参数

Answer 2

BWZGNMJXZXUCJVHMCCFPCMEYREMSXRNLLXFOOHSYENJJXUKRUYWCFYFUJDDOKDRNBUNQQTHSMQDJDFFZZGJJCVJAZWCCOFTWWCNWTSIIOHODQUDDZAQBEUKAHMWUTTDXNQXRHNMDOEEXXOYTMPYJXLBBCDRRUUBBHFKDTVIOENNGDCKURSERRSOCREOOFYBCLQJPCARBPJPQQBAXLTWIJGISPLBBZZKTGTNMLSVCEILVELCVWMFPYSLFWCDUNOOLFOWJZIMFYUAUPYLMVNXQAGOJNPZCSMROSLCXKQTWQIHESFMWZWPHDUFFPQLBHIJHKBUOOPQGJNBVIOICLEDKQAXQVUUUYHUENDQJNHSSXUMGGWZTDOEEONZZOPWQGDGPGNDTKCTPPPPPJCUNXXQOUBLTPISMVIOZGCQDQTDDMSFFYGGWWKKJZWYOBRKKOOOUPPPABNPQOJWBEEMGNATXAKRMKNOOZPDXKOIZWJQDDDKILQLHEOTXGIFVXYXNNNYYYFCGREAHPZEXOOSZTYBYHRPMRPFMPIVYFCLTXDGJYBLYBLURPFSVLTQTMFJDZDUTCUUQGURQIULBKGRGKBPKDPZEUVOTTZUWWAGHUHFVSDWHVSFQGWGSYVSSGXQZVJRXVBGFAUTRSUKGOYFPCMHFOHGHVVBEEOBZSVDYCZUOJMFVRKRVFCVZJTIULLDWUHAHCARYFLILVMTNBXCUUUONHOJJWCMHECBVKPERRWGTDCGANQTNNWEPSKSNTMWGEVZSTQGQCAKKNKKBSEHAAUUEXEBSNABFPGPMGXLOVCPNAKUDAOWMDKHHPVHZDZMNNMMLIPGMQDZQQYYSGARGRFKUNXYICCOVYYOCQJXXMZVSSZDXKTTF

Answer 3

x是输入参数，那么下面x是不能被赋值的，如果想赋值需要改成create or replace procedure test(x in out number)