CREATE PROCEDURE compilation error, what is wrong?
From: Wayne Larimore <dwljr_at_ionet.net>
Date: 1998/09/16
Message-ID: <01bde17a$9d85e720$2a27a8c0_at_computer>#1/1
AS BEGIN
INSERT INTO PROFILE
VALUES (lbx_nbr, descr, modify_by, control1, bank_nbr, control3,
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
RAISE;
END;
Any help will be appreciated,
wayne.larimore_at_alltel.com Received on Wed Sep 16 1998 - 00:00:00 CEST
Date: 1998/09/16
Message-ID: <01bde17a$9d85e720$2a27a8c0_at_computer>#1/1
I am attempting to create a procedure through sqlplus. I have successfully creating other procedures, but the following one is giving me a problem. It does have several parameters (45)... Is there a limit? I don't find any constraints in the manual....
dda_acct_nbr CHAR, deflt_svc_code CHAR, addr1_name_1 CHAR, addr1_name_2 CHAR, addr1_line_1 CHAR, addr1_line_2 CHAR, addr1_line_3 CHAR, addr1_city CHAR, addr1_state CHAR, addr1_zip CHAR, addr2_name_1 CHAR, addr2_name_2 CHAR, addr2_line_1 CHAR, addr2_line_2 CHAR, addr2_line_3 CHAR, addr2_city CHAR, addr2_state CHAR, addr2_zip CHAR, addr3_name_1 CHAR, addr3_name_2 CHAR, addr3_line_1 CHAR,addr3_line_2 CHAR, addr3_line_3 CHAR, addr3_city CHAR, addr3_state CHAR, addr3_zip CHAR, instructions LONG, shell CHAR, status CHAR, ia_node CHAR, ia_node2 CHAR, ia_node3 CHAR, ia_node4 CHAR, ia_node5 CHAR, ia_node6 CHAR, ia_node7 CHAR, ia_node8 CHAR, ia_node9 CHAR)
AS BEGIN
INSERT INTO PROFILE
VALUES (lbx_nbr, descr, modify_by, control1, bank_nbr, control3,
control4, dda_acct_nbr, deflt_svc_code, addr1_name_1, addr1_name_2, addr1_line_1, addr1_line_2, addr1_line_3, addr1_city, addr1_state, addr1_zip, addr2_name_1, addr2_name_2, addr2_line_1, addr2_line_2, addr2_line_3, addr2_city, addr2_state, addr2_zip, addr3_name_1, addr3_name_2, addr3_line_1, addr3_line_2, addr3_line_3, addr3_city, addr3_state, addr3_zip, instructions, shell, status, ia_node, ia_node2, ia_node3, ia_node4, ia_node5, ia_node6, ia_node7, ia_node8, ia_node9);COMMIT;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
RAISE;
END;
Any help will be appreciated,
wayne.larimore_at_alltel.com Received on Wed Sep 16 1998 - 00:00:00 CEST