In Oracle PL/SQL you can declare a record (structure) with specified variables. In Java you can use a plain class with getter and setter methods:
Oracle:
CREATE OR REPLACE PACKAGE name AS TYPE item IS RECORD ( name VARCHAR2(100), desc VARCHAR2(100), notes VARCHAR2(100), ); END; /
Java:
public class Item { private String name; private String desc; private String notes; // Constructor public item(String name, String desc, String notes) { this.name = name; this.desc = desc; this.notes = notes; } // Getter and setter methods public String getName() { return name; } public void setName(String name) { this.name = name; } public String getDesc() { return desc; } public void setDesc(String desc) { this.desc = desc; } public String getNotes() { return notes; } public void setNotes(String notes) { this.notes = notes; } @Override public String toString() { return "item [" + "name=" + name + "desc=" + desc + "notes=" + notes + "]"; } }
For more information, see Oracle PL/SQL to Java Migration.