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

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

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.