This week's giveaway is in the Programmer Certification (OCPJP) forum.
We're giving away four copies of Java Mock Exams (software) and have David Mayer on-line!
See this thread for details.
Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

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

David McCullough
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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";


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(?)}");


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

catch(Exception e)

Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!