CREATE PROCEDURE compilation error, what is wrong?

From: Wayne Larimore <dwljr_at_ionet.net>
Date: 1998/09/16
Message-ID: <01bde17a$9d85e720$2a27a8c0@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....

CREATE PROCEDURE lb.add_profile (lbx_nbr CHAR, descr CHAR, modify_by CHAR,   control1 CHAR, bank_nbr CHAR, control3 CHAR, control4 CHAR,

  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 CDT