create or replace procedure insertPart(
id number,
description varchar2,
unitprice number,
onhand number,
reorder number)
as
language java
name 'Part.insert(
oracle.sql.NUMBER,
oracle.sql.CHAR,
oracle.sql.NUMBER,
oracle.sql.NUMBER,
oracle.sql.NUMBER)';
/
create or replace procedure updatePart(
id number,
description varchar2,
unitprice number,
onhand number,
reorder number)
as
language java
name 'Part.update(
oracle.sql.NUMBER,
oracle.sql.CHAR,
oracle.sql.NUMBER,
oracle.sql.NUMBER,
oracle.sql.NUMBER)';
/
create or replace procedure deletePart (id number)
as
language java
name 'Part.delete(oracle.sql.NUMBER)';
/