Home » SQL & PL/SQL » SQL & PL/SQL » Varry Data Type in 10G
Varry Data Type in 10G [message #233649] Fri, 27 April 2007 01:50 Go to next message
atulrsingh
Messages: 55
Registered: November 2006
Location: Mumbai
Member
Hi All,

I have one table which has one column whose datatype is varray datatype.

I am able to query it in 9i but not in 10G.

checkout the last column in the list.

PL_SESSION_NO NUMBER(11),
PL_POLICY_NO VARCHAR2(15 BYTE),
PL_POLICY_RENEW_NO VARCHAR2(2 BYTE),
PL_SLNO NUMBER(3) NOT NULL,
PL_LOCATION_CODE VARCHAR2(8 BYTE),
PL_MASTER_CODE VARCHAR2(8 BYTE) NOT NULL,
PL_RATE_STRUCT_CODE NUMBER(3),
PL_BEGIN_DATE DATE NOT NULL,
PL_END_DATE DATE,
PL_PRIMARY_LOCATION VARCHAR2(1 BYTE),
PL_FLOOR_PLAN VARCHAR2(1 BYTE),
PL_LIABILITY_TERRITORY VARCHAR2(3 BYTE) NOT NULL,
PL_RATING_DATE DATE,
PL_LATITUDE NUMBER(8,4),
PL_LONGITUDE NUMBER(8,4),
PL_OCCUPANCY VARCHAR2(3 BYTE),
PL_CURR_OWNERSHIP_NO_OF_YEARS NUMBER(3),
PL_BLEND_GROUP_CODE VARCHAR2(8 BYTE),
PL_WT_GROUP_CODE VARCHAR2(8 BYTE),
PL_MATCHED_GROUP_CODE VARCHAR2(8 BYTE),
PL_OWNERSHIP_GROUP_CODE VARCHAR2(8 BYTE),
PL_DEL_FLAG VARCHAR2(1 BYTE),
PL_EDR_SESSION_NO NUMBER(11),
PL_EDR_EFF_DATE DATE,
PL_EDR_CODE VARCHAR2(7 BYTE),
PL_CREATED_ON DATE NOT NULL,
PL_CREATED_BY VARCHAR2(15 BYTE) NOT NULL,
PL_MODIFIED_ON DATE,
PL_MODIFIED_BY VARCHAR2(15 BYTE),
PL_PRIOR_LOC_CODE VARCHAR2(8 BYTE),
PL_FALSE_PRETENSE_LIMIT VARCHAR2(20 BYTE),
PL_LOSS_REPORTING_FROM DATE,
PL_LOSS_REPORTING_TO DATE,
PL_MATCHED_TO VARCHAR2(8 BYTE),
PL_FLOOD_EXCLUDED VARCHAR2(3 BYTE) DEFAULT NULL,
PL_FLOOD_DEDUCTIBLE VARCHAR2(20 BYTE),
PL_RATE_GRID_CODE NUMBER(3),
PL_GROUP_CODE VARCHAR2(10 BYTE),
PL_LOCATION_SLNO NUMBER(20),
PL_BUILDING_SLNO NUMBER(20),
PL_MASTER_LOC_CODE VARCHAR2(8 BYTE),
PL_RATE_YN VARCHAR2(1 BYTE),
PL_PROTECTION_CLASS VARCHAR2(2 BYTE),
PL_YEAR_BUILT NUMBER(4),
PL_RENOVATION_YEAR NUMBER(4),
PL_CONSTRUCTION_TYPE VARCHAR2(3 BYTE),
PL_TOTAL_SQUARE_FOOTAGE NUMBER(10,2),
PL_SPRINKLRED_PERC NUMBER(5,2),
PL_NO_OF_STORIES NUMBER(4),
PL_REMARKS VARCHAR2(4000 BYTE),
PL_NO_OF_YEARS_BUSINESS NUMBER(4,1),
PL_SAFETY_FEATURES SAFETY_FEATURES_VARRAY


" PL_SAFETY_FEATURES SAFETY_FEATURES_VARRAY
"

Need some solution for the same

Thnx
Atul
Re: Varry Data Type in 10G [message #233655 is a reply to message #233649] Fri, 27 April 2007 01:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Copy and paste what you did in SQL*Plus.
With what you posted there is nothing we can say but "if you say you have an error then you have an error".

Regards
Michel
Re: Varry Data Type in 10G [message #233687 is a reply to message #233649] Fri, 27 April 2007 03:12 Go to previous messageGo to next message
atulrsingh
Messages: 55
Registered: November 2006
Location: Mumbai
Member
i executed the query

select * from POLICY_LOCATIONS

and i am getting this error

"Data type is not supported."


Re: Varry Data Type in 10G [message #233689 is a reply to message #233687] Fri, 27 April 2007 03:14 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
COPY AND PASTE
All statements from create to error.

Regards
Michel
Previous Topic: How to look at stored prcedures
Next Topic: imp and exp in oracle
Goto Forum:
  


Current Time: Sat Dec 03 18:31:33 CST 2016

Total time taken to generate the page: 0.12928 seconds