Home » Oracle FAQ Knowledge Base » Server Options » JServer

How does one call/execute a Java Stored Procedure?

Submitted by admin on Sat, 2005-11-26 02:46.
  • From SQL*Plus: Use execute or call
  • From JDBC: Use the CallableStatement object
  • From SQLJ: #sql { call ...} eg: #sql { call ACME.BEGINRENTAL(:in memberID, :in employeeID, :out, ...) };
    ‹ How does one drop a Java Stored Procedure from the database?upWhat happens when you write to the console from a Java Stored Procedure? ›
    »