#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2006
    Posts
    1
    Rep Power
    0

    Question PLS-00201: identifier 'TEST_PROC' must be declared


    Hi,
    I am new to stored procs and I am trying to call a stored proc from a shell script and it gives me an error like
    ERROR at line 1:
    ORA-06550: line 1, column 7:
    PLS-00201: identifier 'TEST_PROC' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored

    My shell script looks like this:-
    #
    # Runs the stored procedure to create a books table
    #

    export ORACLE_HOME=/opt/oracle/OraHome1

    export PATH=$PATH:/opt/oracle/OraHome1/bin

    echo ".....Starting create of books table......"

    echo $CLASSPATH

    set serveroutput on size 1000000

    sqlplus username/password@SID << EOF

    exec TEST_PROC

    EOF

    echo ".....Ending Data Load from AF to PH....."

    Any help will be greatly appreciated.

    Thanks,
    SM
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2006
    Location
    Carlsbad, CA
    Posts
    2,055
    Rep Power
    383
    Does the user you are logging in as have execute rights on TEST_PROC?

IMN logo majestic logo threadwatch logo seochat tools logo