Re: CREATE PROCEDURE compilation error, what is wrong?

I know in SQL Worksheet you can type: "SHOW ERRORS" and it will tell you what the error is (cross reference the error manual on what action to take.)

or type the following: select * from user_errors;

-Frank

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