map.sql

来自「orale培训教材包括了所有的sql说明和实例」· SQL 代码 · 共 37 行

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)';
/