AnsweredAssumed Answered

Can CA data maker tool support RAW, LONG , BLOB and Object datatype (database: Oracle) ?

Question asked by NEW_ACCOUNT on Feb 21, 2018
Latest reply on Feb 22, 2018 by NEW_ACCOUNT

Can CA data maker tool support RAW, LONG , BLOB and Object datatype (database: Oracle) ?

If yes, Please provide the document to refer.

I tried for  Object datatype but this is not working.

In source:

Step1

CREATE TYPE address_typ AS OBJECT (
adr1 VARCHAR2(100),adr2 VARCHAR2(100),street VARCHAR2(30),city VARCHAR2(20),state CHAR(2),postal_code VARCHAR2(6) );
/

Step2

CREATE table employee_det (
employee_id NUMBER(6),first_name VARCHAR2(20),last_name VARCHAR2(25),email VARCHAR2(25),
phone_number VARCHAR2(20),address_det address_typ);

 

Step3

INSERT INTO employee_det VALUES (3,'grrhi','klrra','c@c.com','1234567890',
address_typ('adr3', 'adr4', 'street4', 'bangalore','KA','560100'))

 

Step4

Registered the table in Data maker

 

Step5

When setting action for Registered object getting error:

Select Error: ORA-01013: user requested cancel of current operation

while executing

SELECT * FROM employee_det

 

Thank you in Advance.

Outcomes