Stack Overflow
Stack Overflow

Questions tagged [oracle-objects]

Oracle Objects are a (somewhat) object oriented extension to PL/SQL and SQL for the Oracle RDBMS.

Oracle Objects are a (somewhat) object oriented extension to PL/SQL and SQL for the Oracle RDBMS.

To quote the documentation

Oracle object types are user-defined types that make it possible to model real-world entities, such as customers and purchase orders, as objects in the database.

14 questions
3
votes
1 answer

How to know the type of :new in a trigger?

Let's suppose that I have these dummy types and tables of these types: create or replace type Tariff_Plan_TY as object( tariff_id INTEGER, call_price DECIMAL(3,2), sms_price DECIMAL(3,2), )FINAL; create or replace type Contract_TY as object( …
juuso
  • 612
  • 7
  • 26
1
vote
2 answers

RTTI in Oracle Triggers

I have this dummy types : create or replace type Service_TY as object( code INTEGER, visit_analysis char(1) )FINAL; / create or replace type Employee_TY as object( dummy varchar(30) )NOT FINAL; / create or replace type Doctor_TY UNDER…
juuso
  • 612
  • 7
  • 26
1
vote
2 answers

How can I return a own type data in oracle stored procedure?

I create a type data in oracle for a procedure. procedure: create or replace TYPE ROW_USER as object ( ID NUMBER(4), ROLES_ID NUMBER(1), FIRST_NAME VARCHAR2(60 BYTE), SECOND_NAME …
Diego F
  • 19
  • 1
1
vote
1 answer

Oracle Object Types

In my lectures I learnt about ORACLE OBJECT TYPES mentioning COLUMN OBJECT and ROW OBJECT. I don't find enough details in my lectures regarding the object types. I have googled a lot to find at least a article about these object types, but I was…
Ramesh
  • 2,297
  • 2
  • 20
  • 42
1
vote
1 answer

get value of reference of a nested table

I'm trying to write a query in to get IP address which is a reference of a nested table of a table that is reference of another nested table. create type t_pc as object ( Nserie number(20), adrIP VARCHAR(20), cpu VARCHAR(20) …
ELASRI Mohamed
  • 23
  • 7
1
vote
2 answers

How to map Oracle Object type in an entity using Spring Data JPA?

This question is particularly related to mapping Oracle object type in an entity using Spring Data JPA. The other question did not help explain the problem in detail. So here below are details: I could not find information related to mapping Oracle…
Uresh K
  • 1,136
  • 11
  • 16
0
votes
0 answers

Passing Oracle Object containing Blob to SimpleJdbcCall

I have Oracle objects defined as follows: create or replace TYPE "FILEIITEM_OBJ" AS OBJECT ( FILENAME VARCHAR2(100) ,CONTENT BLOB ); and create or replace TYPE "FILEITEM_COLL" IS TABLE OF FILEITEM_OBJ; I need to call a procedure…
Jason
  • 3,943
  • 12
  • 64
  • 104
0
votes
1 answer

How to pass object of object type as a parameter in oracle

This is the next level question for how to pass object type as a parameter in oracle. My question is in the same context a bit deeper with master-child nested level relationship, which is object with in the object. And I didn't find any way to call…
Sangi Dan Paliwal
  • 3
  • 4
0
votes
2 answers

JDBC working with Oracle RECORD, TABLE and OBJECT types

How to retrieve Oracle Collection Types in Jdbc. I searched a lot but not found any answer. Below is my stored procedure working fine : create or replace PACKAGE SHOW_SUP AS TYPE SUP_COF_REC IS RECORD ( SUPPLIER_NAME VARCHAR2(32), …
Nizam
  • 573
  • 1
  • 5
  • 12
0
votes
1 answer

XML data formation using object types

I need to generate XML using Oracle object types and element will have attributes. The complication is both element and attribute will have values as below employee> ename id=100>Aaron /ename> /employee> Requirement is to achieve this with…
Nagesh Bhat
  • 1
  • 2
0
votes
1 answer

Returning Object Type from Oracle Procedure by partially populating it?

I have created an Object Type in Oracle as below: CREATE OR REPLACE TYPE Generic_MDMU_Scrub_Cols_OBJ as Object ( i_strTypeOfEntry varchar2(50), ID_SCRUB number, NM_DATA_COL1 varchar2(50), NM_DATA_COL2 varchar2(50), NM_DATA_COL3…
abhihello123
  • 1,668
  • 1
  • 22
  • 38
0
votes
1 answer

Oracle database object type import in JPA

Is there a way to import oracle defined object type in JPA. I have a complex object defined in database : create or replace TYPE "myType"{ someString varchar2(100), someString2 varchar2(100), constructor....} this object type is than used in a…
user1820622
  • 85
  • 2
  • 6
-1
votes
1 answer

printing information about sub-type within a nested table

Here's the schema: CREATE OR REPLACE TYPE Component_ty AS OBJECT ( Code VARCHAR(10), Component_Description VARCHAR(100), Component_Type VARCHAR(10)) NOT FINAL; CREATE OR REPLACE TYPE External_Component_ty UNDER Component_ty( External_Company REF…
mikerug88
  • 135
  • 8
-1
votes
1 answer

replacement for cast and collect in oracle

I want to convert the below statement into normal query. SELECT CAST(COLLECT(warehouse_name ORDER BY warehouse_name) AS warehouse_name_t) "Warehouses" FROM warehouses; How to do this? I tried some of the things but could not succeed. Please help.
Anjali
  • 1,623
  • 5
  • 30
  • 50