Re: CREATE PROCEDURE compilation error, what is wrong?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1998/09/16
Message-ID: <3608cc62.82618258@192.86.155.100>#1/1

A copy of this was sent to "Wayne Larimore" <dwljr_at_ionet.net> (if that email address didn't require changing) On 16 Sep 1998 13:58:54 GMT, you 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....

nope thats not the problem.

after you run the create procedure statment in sqlplus, issue:

SQL> show errors procedure add_profile

that'll tell you whats wrong. I don't have the definition of your PROFILE table but the problem is either

• the table profile doesn't exist, you'll see:

Errors for PROCEDURE ADD_PROFILE:

LINE/COL ERROR

-------- -----------------------------------------------------------------
16/3     PL/SQL: SQL Statement ignored

16/15 PLS-00201: identifier 'PROFILE' must be declared

if thats the case.

• the table profile has a different number of columns then you are trying to insert. You'll see:

Errors for PROCEDURE ADD_PROFILE:

LINE/COL ERROR

-------- -----------------------------------------------------------------
16/3     PL/SQL: SQL Statement ignored
17/12    PLS-00395: wrong number of values in VALUES clause of INSERT
         statement

if thats the case.

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

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/    -- downloadable utilities
 
----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation
 
Anti-Anti Spam Msg: if you want an answer emailed to you, 
you have to make it easy to get email to you.  Any bounced
email will be treated the same way i treat SPAM-- I delete it.

Received on Wed Sep 16 1998 - 00:00:00 CDT