aspose file tools*
The moose likes JDBC and the fly likes PLS-00201: identifier 'SEC_LBIC.LDAP_VIEW_APP_LIST' must be declared Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "PLS-00201: identifier Watch "PLS-00201: identifier New topic
Author

PLS-00201: identifier 'SEC_LBIC.LDAP_VIEW_APP_LIST' must be declared

David McCullough
Greenhorn

Joined: Nov 12, 2004
Posts: 3
java.sql.SQLException: ORA-06550: line 1, column 13:
PLS-00201: identifier 'SEC_LBIC.LDAP_VIEW_APP_LIST' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

I am getting this error when calling the following PL/SQL stored procedure from Java.


String wwid = "20300474";



try
{

Context initcxt = new InitialContext();
writer.println("Initial Context");
Context envCtx = (Context) initcxt.lookup("java:comp/env");
writer.println("looking up Context");
DataSource ds = (DataSource)envCtx.lookup("jdbc/jnj/security");
writer.println("Got initial Context!");


Connection conn = ds.getConnection();





CallableStatement cstmt = conn.prepareCall("{? = call SEC_LBIC.ldap_view_app_list(?)}");
cstmt.registerOutParameter(1,OracleTypes.CURSOR);
cstmt.setString(2,wwid);

cstmt.executeUpdate();




writer.println("SUCCESSFUL - update of Stored Procedure..");
}

catch(Exception e)
{
writer.println(e.getStackTrace());
e.printStackTrace();

}


Please no SPAM!!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: PLS-00201: identifier 'SEC_LBIC.LDAP_VIEW_APP_LIST' must be declared
 
Similar Threads
WAS4 datasource issue
java.sql.SQLException: Pls Help
call to oracle sp
new to oracle How to execute Stored Procedure
Loadjava and user_objects table