PLS-00302: component 'variable' must be declared
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: PLS-00302: component 'variable' must be declared

  1. #1
    Join Date
    Dec 2002
    Posts
    62

    PLS-00302: component 'variable' must be declared

    Hi All,

    Create package body .......

    PROCEDURE load(p VARCHAR2,ps psys%ROWTYPE default NULL)
    IS
    v_con con%ROWTYPE default null;
    BEGIN
    IF p_src = 'system' THEN
    v_con.cnt_person_id := ps.customer_id ;
    Endif;
    ......

    When I compile this package it gives following error

    LINE/COL ERROR
    -------- ------------------------------------------------------------
    16/10 PL/SQL: Statement ignored
    16/20 PLS-00302: component 'CNT_PERSON_ID' must be declared

    Can anybody help me out.
    thanks in advance.

  2. #2
    Join Date
    May 2002
    Posts
    108
    Invalid column name. Check if cnt_person_id is a valid column name(Check underscores etc.,)

    - Nandu
    Never give up !

    Nanda Kumar - Vellore

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width