Guest.Visitor
01-01-1995, 02:00 AM
Hi, I am calling a stored procedure that has four input parameter and 2 output parameters. See below to see code. I am able to connect to the 400 fine but when it goes to call the procedure I get the following error: "java.sql.SQLException: SQL0204 ID_NAME_LS in ROBERT type *N not found. Cause . . . . . : ID_NAME_LS in ROBERT type *N was not found. If this is an ALTER TABLE statement and the type is *N, a constraint was not found. If this is NOT an ALTER TABLE statement and the type is *N, a function or procedure was not found. Recovery . . . : Change the name and try the request again. If the object is a node group, ensure that the DB2 Multisystem product is installed on your system and create a nodegroup with the CRTNODGRP CL command." Here is the code used to connect to the 400 and to call the procedure: public void connectToDB(String name, String password, String systemName) throws Exception{ try{ DriverManager.registerDriver(new com.ibm.as400.access.AS400JDBCDriver()); connection = DriverManager.getConnection("jdbc:as400://" + systemName + "/ROBERT;naming=sql;errors=full;date format=iso;extended dynamic=true ", name, password); CallableStmt = connection.prepareCall("CALL ROBERT.ID_NAME_LS(?, ?, ?, ?, ?, ?)"); CallableStmt.registerOutParameter(5, Types.VARCHAR); CallableStmt.registerOutParameter(6, Types.VARCHAR); } catch(Exception e) {e.printStackTrace(); System.out.println("DIDNOT CONNECT"); } return; } I am new to call stored procedure on the 400 also I am not sure what the error message is trying to say. This procedure is in the library Robert so I am not sure what is going on. So if anyone knows why I am getting this error, or know how to fix it your help would be greatly appreciated. Thanks again Amie Ramczyk