Hi All,
I created the object type and then given reference to table. I want to
select the data from table.
For Ex:
create type pur_obj_array as object
(
PURCHASE_CODE VARCHAR2(100),DCO_ID INTEGER,MNO_ID INTEGER,
TERMINAL_ID VARCHAR2(32),SUBSCRIBER_ID VARCHAR2(25),SUBSCRIPTION_TYPE
VARCHAR2(25),
SUBSCRIPTION_START_DATE DATE,SUBSCRIPTION_END_DATE DATE,
LAST_RO_DELIVERY_DATE DATE,NEXT_CHARGING_DATE DATE,
LAST_TRIGGER_DELIVERY_DATE DATE,IS_ACTIVE INTEGER,EVENT_TYPE
VARCHAR2(50),
IS_PROCESSED INTEGER,RECKON NUMBER,PURCHASE_DATE DATE,PRICE
NUMBER(16,2),
IS_CHARGEABLE CHAR(1),IS_CANCELABLE CHAR(1),VALIDITY_END_DATE DATE,
MODIF_DATE DATE,isnew Integer);
create type pur_obj_arraylist as table of pur_obj_array;
create table purchase_object(id number,pur_object
pur_obj_arraylist,modif_date date)
nested table pur_object store as pur_object_tbl;
I have stored the data in Purchase_object table and I want to see the
data from purchase_object table.
If I give select * from purchase_object I am getting following error.
ORA-21500 Internal error code [%s][%s][%s][%s]
How to select the data from such type of tables.
Please help.
Thanking you.
Regards
Gajanan Rao Patwari
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.
www.wipro.com
Oracle LazyDBA home page