Re: CREATE PROCEDURE compilation error, what is wrong?

Dear Mr. Larimore: Your proc compiles just fine for me.(I removed your insert statement and tried). May be your compilation error has got something to do with priviliges. Let me know the error msg. -Kumar In article <01bde17a$9d85e720$2a27a8c0_at_computer>, "Wayne Larimore" <dwljr_at_ionet.net> wrote:

> 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
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Sep 16 1998 - 00:00:00 CDT