Results 1 to 4 of 4

Thread: Pls -00201

  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Unanswered: Pls -00201

    Hi people,
    Im a newbie here and i need a little help
    I have a procedure that compiles and executes fine on oracle 9i sql*plus.
    I am calling the procedure in my database class in java. When i do so i get the following runtime error..

    Darn! A SQL error: ORA-06550: line 1, column 7:
    PLS-00201: identifier 'FIND_ADJ_NODE1_PROC' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored

    this is the method in the db class...
    public String findAdjacentNode1(String currNode)
    {

    //Connection conn = null;
    CallableStatement stmt = null;
    ResultSet rset = null;
    Date result;
    int status;
    String adjNode1;
    try {
    //conn = DriverManager.getConnection(
    //"jdbcracle:thin:@nc-oracle-2.students.ittralee.ie:1521rcl","kate","oracle");

    stmt = this.DBConnection.prepareCall("{call find_adj_node1_proc(?,?,?)}");
    result = null;
    stmt.registerOutParameter(2,java.sql.Types.VARCHAR );
    stmt.registerOutParameter(3,java.sql.Types.INTEGER );
    stmt.setString(1,currNode);
    stmt.execute();
    adjNode1 = stmt.getString( 2);
    status = stmt.getInt(3);

    System.out.println("the return parameter is : " + adjNode1);
    System.out.println("the return parameter is : " + status);

    DBConnection.close();
    stmt = null;
    DBConnection.close();
    DBConnection = null;
    //Callable stmt =null;
    //ResultSet rs = null;
    //
    }
    catch(SQLException e)
    {
    System.out.println("Darn! A SQL error: " + e.getMessage());
    }
    finally
    {
    if (rs != null)
    try {rs.close();} catch(SQLException ignore) {}
    if (stmt != null)
    try {stmt.close();} catch(SQLException ignore) {}
    }

    return this.adjNode1;

    }


    and this is just a test class where i am calling the method...
    public class ProcTest
    {
    private static Database db;
    public static void main(String [] args)
    {
    db = new Database();
    db.getDriver();
    db.createConnection();
    System.out.println("Adj node 1 hopefully! " + db.findAdjacentNode1("AAA"));
    }
    }


    any help would be greatly appreciated

  2. #2
    Join Date
    Feb 2004
    Location
    Charlotte, NC
    Posts
    79
    Probably a good place to start would be to look at privileges. You may need to explicitly allow privileges to the user whose user ID you are logging on with.

    That error occurs on the very first line and your procedure compiled OK, so I would suspect a privilege error or something similar.
    Make something idiot proof and someone will make a better idiot...

  3. #3
    Join Date
    Mar 2004
    Posts
    2
    Originally posted by robojam
    Probably a good place to start would be to look at privileges. You may need to explicitly allow privileges to the user whose user ID you are logging on with.

    That error occurs on the very first line and your procedure compiled OK, so I would suspect a privilege error or something similar.
    Thanks robojam, im on a college system so i dont know how receptive they will be to the idea of changing privileges If i tried to how would i go about changing privileges...

    Thanks in advance

  4. #4
    Join Date
    Feb 2004
    Location
    Charlotte, NC
    Posts
    79
    You would need to contact the database administrator. It's not that you need privileges to do all kinds of dangerous things like destroy the database, so I'm sure they would be more receptive to just allowing you to run a stored procedure.
    Make something idiot proof and someone will make a better idiot...

Posting Permissions

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