Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"No schema definition" error?

23331Oct 5 2006 — edited Oct 10 2006
Using Oracle Database 10g Release 10.2.0.1.0 and SQL*Plus: Release 10.2.0.1.0 I am trying to register the following schema:
--------------------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<!--W3C Schema -->
<!-- Edited by Subbu on 02/12/01-->
<xsd:schema xmlns:xsd="http://www.w3.org/2000/10/XMLSchema" elementFormDefault="qualified">
<xsd:include schemaLocation="http://oasis.caiso.com/MainTypes.xsd"/>
<xsd:element name="ORGANIZATION">
<xsd:complexType mixed="true">
<xsd:choice minOccurs="0" maxOccurs="unbounded">
<xsd:element name="REPORT_ITEM">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="HEADER">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="REPORT" type="reportType"/>
<xsd:element name="SYSTEM" type="systemType"/>
<xsd:element name="TZ" type="timeZoneType"/>
<xsd:element name="MKT_TYPE" type="marketType" nullable="true" minOccurs="0"/>
<xsd:element name="SCHED_CLASS" type="schedClassType" nullable="true" minOccurs="0"/>
<xsd:element name="UOM" type="uomType" nullable="true" minOccurs="0"/>
<xsd:element name="INTERVAL">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="BEGINNING"/>
<xsd:enumeration value="ENDING"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="SEC_PER_INTERVAL" type="xsd:integer"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="DATA" maxOccurs="unbounded">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="DATA_ITEM" type="xsd:string" nullable="true"/>
<xsd:element name="SOURCE" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="SINK" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="RESOURCE_NAME" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="OPR_DATE" type="xsd:date" nullable="true" minOccurs="0"/>
<xsd:element name="BEGIN_DATE" type="xsd:date" nullable="true" minOccurs="0"/>
<xsd:element name="END_DATE" type="xsd:date" nullable="true" minOccurs="0"/>
<xsd:element name="BEGIN_HE" type="xsd:integer" nullable="true" minOccurs="0"/>
<xsd:element name="END_HE" type="xsd:integer" nullable="true" minOccurs="0"/>
<xsd:element name="LINE_RATINGS" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="EQUIPMENT_OUTAGE" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="NOTES" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="INTERVAL_NUM" type="xsd:integer" nullable="true" minOccurs="0"/>
<xsd:element name="VALUE" type="xsd:double" nullable="true" minOccurs="0"/>
<xsd:element name="SVALUE" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="STATUS_TYPE" type="xsd:string" nullable="true" minOccurs="0"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="ATLS_ITEM">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="ATLS_HEADER">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="REPORT" type="reportType"/>
<xsd:element name="SYSTEM" type="systemType"/>
<xsd:element name="TZ" type="timeZoneType"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="ATLS_DATA" maxOccurs="unbounded">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="PUB_DATE" type="xsd:date" nullable="true" minOccurs="0"/>
<xsd:element name="PUB_TIME" type="xsd:time" nullable="true" minOccurs="0"/>
<xsd:element name="PUB_TYPE" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="MKT_TYPE" type="marketType" nullable="true" minOccurs="0"/>
<xsd:element name="OPR_DATE" type="xsd:date" nullable="true" minOccurs="0"/>
<xsd:element name="INTERVAL" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="SEC_PER_INTERVAL" type="xsd:integer" nullable="true" minOccurs="0"/>
<xsd:element name="INTERVAL_NUM" type="xsd:integer" nullable="true" minOccurs="0"/>
<xsd:element name="OPR_HR" type="xsd:integer" nullable="true" minOccurs="0"/>
<xsd:element name="OPR_MIN" type="xsd:integer" nullable="true" minOccurs="0"/>
<xsd:element name="VS_NUM" type="xsd:integer" nullable="true" minOccurs="0"/>
<xsd:element name="PUB_INTERVAL" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="STND_PUB_TIME" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="BRANCH_GRP" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="BRANCH_CODE" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="SUFFIX_ID" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="LOAD_ID" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="UNIT_ID" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="UDC_AREA" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="EXT_DMD_ZN" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="CNGS_ZONE" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="DEMAND_ZONE" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="LOAD_GRP" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="CONG_ZONE" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="CNGS_ZONE_FROM" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="CNGS_ZONE_TO" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="INTL_CONT_AREA" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="ACT_FIELD" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="TIE_POINT" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="ERR_CODE" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="ERR_DESC" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="SEVERITY_LVL" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="DESCRIPTION" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="STATUS" type="statusType" nullable="true" minOccurs="0"/>
<xsd:element name="COMMENTS" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="RPT_GRP" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="EFFECTIVE_DATE" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="REF_NAME" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="UPDATE_DATE" type="xsd:date" nullable="true" minOccurs="0"/>
<xsd:element name="OLD_SECTION" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="OLD_VIEW" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="OLD_SUBVIEW" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="OLD_RPT_NAME" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="OLD_EFF_DATE" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="OLD_TEMPLATE_NAME" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="OLD_TEMPLATE_FIELD" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="TAB_LOC" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="MKT_TYPE" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="SCH_CLASS" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="RPT_NAME" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="RPT_FLD_NAME" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="XML_RPT_NAME" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="XML_DATA_ITEM" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="RPT_GRP" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="MAT_COMMENTS" type="xsd:string" nullable="true" minOccurs="0"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="DISCLAIMER_ITEM">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="DISCLAIMER" type="xsd:string"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="ERROR">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="ERR_CODE" type="xsd:string" nullable="true" minOccurs="0"/>
<xsd:element name="ERR_DESC" type="xsd:string" nullable="true" minOccurs="0"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:choice>
</xsd:complexType>
</xsd:element>
</xsd:schema>

--------------------------------------------------------------------------------------
using the following:
--------------------------------------------------------------------------------------

declare
fileonos bfile;
begin
fileonos := bfilename('OASIS_SCHEMA_DIR', 'oasisv003.xsd');
dbms_xmlschema.registerschema('oasisv003_for_oracle.xsd', fileonos,
TRUE, TRUE, FALSE, TRUE, FALSE);
end;
/
--------------------------------------------------------------------------------------
but it gets errors:
--------------------------------------------------------------------------------------

ERROR at line 1:
ORA-30937: No schema definition for 'schema' (namespace
'http://www.w3.org/2000/10/XMLSchema') in parent '/'
ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 37
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 61
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 126
ORA-06512: at line 5
--------------------------------------------------------------------------------------
After some massaging, and incorporating the referenced maintypes.xsd, now have schema that registers succesfully that looks like:
--------------------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<!--W3C Schema -->
<!-- Edited by Subbu on 02/12/01-->
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://oasis.caiso.com/oasisv003.xsd" targetNamespace="http://oasis.caiso.com/oasisv003.xsd" elementFormDefault="qualified" xmlns:oraxdb="http://xmlns.oracle.com/xdb">
<xsd:simpleType name="reportType">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="AS_BG_INTRCHNG"/>
<xsd:enumeration value="AS_FINAL_MCP"/>
<xsd:enumeration value="AS_MKTGOALS_MW"/>
<xsd:enumeration value="AS_MKTGOALS_PERC"/>
<xsd:enumeration value="AS_OP_RSRV_IMPORT"/>
<xsd:enumeration value="AS_OP_RSRV_REQ"/>
<xsd:enumeration value="AS_PRE_RB_MCP"/>
<xsd:enumeration value="AS_RESULTS"/>
<xsd:enumeration value="AS_SUMMARY"/>
<xsd:enumeration value="ATLS_GPD_RPT_REF"/>
<xsd:enumeration value="ATLS_MF_BG_REF"/>
<xsd:enumeration value="ATLS_MF_LD_REF"/>
<xsd:enumeration value="ATLS_MF_RSRC_REF"/>
<xsd:enumeration value="ATLS_MF_TIE_REF"/>
<xsd:enumeration value="ATLS_MF_ZONE_REF"/>
<xsd:enumeration value="ATLS_OASIS_RPT_REF"/>
<xsd:enumeration value="ATLS_OPR_SYS_MSG"/>
<xsd:enumeration value="ATLS_PUB_REV"/>
<xsd:enumeration value="ATLS_PUB_SCHED_REF"/>
<xsd:enumeration value="ATLS_XML_ERR_MSG"/>
<xsd:enumeration value="EXP_10MIN_PRC"/>
<xsd:enumeration value="EXP_10MIN_REGIONAL_DEF"/>
<xsd:enumeration value="EXP_AMP_STAT"/>
<xsd:enumeration value="EXP_ENG_AB_CAP"/>
<xsd:enumeration value="EXP_ENGY_PRC"/>
<xsd:enumeration value="EXP_INTR_ZONE_CNGS_PRC"/>
<xsd:enumeration value="EXP_LMPM_STAT"/>
<xsd:enumeration value="EXP_MAX_MCP"/>
<xsd:enumeration value="EXP_MOO_MNL"/>
<xsd:enumeration value="EXP_PROXY_STAT"/>
<xsd:enumeration value="FCST_ATC"/>
<xsd:enumeration value="FCST_CNGS_BG"/>
<xsd:enumeration value="FCST_FUEL_PRC"/>
<xsd:enumeration value="FCST_GMM"/>
<xsd:enumeration value="FCST_HA_BG_DRATE"/>
<xsd:enumeration value="FCST_IMB_ENG"/>
<xsd:enumeration value="FCST_LINE_OUTAGE"/>
<xsd:enumeration value="FCST_PEAK_LOAD"/>
<xsd:enumeration value="FCST_RMR"/>
<xsd:enumeration value="FCST_RSRV_REQ"/>
<xsd:enumeration value="FCST_TMM"/>
<xsd:enumeration value="FCST_TRNS_USAGE"/>
<xsd:enumeration value="FCST_UDC_DAC_LD"/>
<xsd:enumeration value="PBD_AS_MKT"/>
<xsd:enumeration value="PBD_CONG_MKT"/>
<xsd:enumeration value="PBD_EXP_MKT"/>
<xsd:enumeration value="RTM_10MIN_STTL_PRC"/>
<xsd:enumeration value="RTM_5MIN_DIS_ENGY_INFO"/>
<xsd:enumeration value="RTM_5MIN_DIS_PRC_INFO"/>
<xsd:enumeration value="RTM_AMP_STAT"/>
<xsd:enumeration value="RTM_FUEL_PRC"/>
<xsd:enumeration value="RTM_HRLY_ENGY_PRC"/>
<xsd:enumeration value="RTM_IZ_CONG_IFACE"/>
<xsd:enumeration value="RTM_IZ_REDISPATCH"/>
<xsd:enumeration value="RTM_LMPM_STAT"/>
<xsd:enumeration value="RTM_MOO_MLC"/>
<xsd:enumeration value="RTM_MOO_MNL"/>
<xsd:enumeration value="RTM_RMR_DISPATCH_ZONE"/>
<xsd:enumeration value="RTM_MOO_COMM_RESULTS"/>
<xsd:enumeration value="SLD_IOU_LOAD_MW"/>
<xsd:enumeration value="SLD_LOAD_GW"/>
<xsd:enumeration value="SLD_LOAD_MW"/>
<xsd:enumeration value="SRS_GMM"/>
<xsd:enumeration value="SRS_LOAD_MUNI"/>
<xsd:enumeration value="SRS_LOAD_RSRC"/>
<xsd:enumeration value="SRS_TMM"/>
<xsd:enumeration value="SRS_UDC_LOSS"/>
<xsd:enumeration value="TRNS_ACT_SCHED_FLW"/>
<xsd:enumeration value="TRNS_ATC"/>
<xsd:enumeration value="TRNS_BG_CNGS_MKT_SUM"/>
<xsd:enumeration value="TRNS_BG_CNGS_STLMNT"/>
<xsd:enumeration value="TRNS_BG_CNGS_USAGE_CHRG"/>
<xsd:enumeration value="TRNS_CNGS_ZONE_REF_PRC"/>
<xsd:enumeration value="TRNS_INTR_ZONE_CNGS_SUM"/>
<xsd:enumeration value="TRNS_TAR"/>
<xsd:enumeration value="TRNS_ZONAL_CNGS_PRC_DIF"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="marketType">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="A"/>
<xsd:enumeration value="B"/>
<xsd:enumeration value="D"/>
<xsd:enumeration value="E"/>
<xsd:enumeration value="F"/>
<xsd:enumeration value="H"/>
<xsd:enumeration value="R"/>
<xsd:enumeration value="N/A"/>
<xsd:enumeration value="All"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="mktSubClassType">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Forecasted_UDC_Direct_Access_Load"/>
<xsd:enumeration value="Day_Ahead_RMR"/>
<xsd:enumeration value="Ten_Min_Expost_Market_Info"/>
<xsd:enumeration value="Day_Ahead_Interim_Market_Info"/>
<xsd:enumeration value="Day_Ahead_Final_Market_Info"/>
<xsd:enumeration value="TTC/ATC_Forecast_Information"/>
<xsd:enumeration value="TTC/ATC_Hourly_Forecast"/>
<xsd:enumeration value="Branch_Group_Derates"/>
<xsd:enumeration value="Hour_Ahead_Market_Info"/>
<xsd:enumeration value="Hourly_Expost_Market_Info"/>
<xsd:enumeration value="Public_Bid_Data"/>
<xsd:enumeration value="Day_Ahead_Forecast_Information"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="measureType">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="MW"/>
<xsd:enumeration value="MWh"/>
<xsd:enumeration value="US$"/>
<xsd:enumeration value="%"/>
<xsd:enumeration value="INTEGER"/>
<xsd:enumeration value="FLAG"/>
<xsd:enumeration value="US$/MW"/>
<xsd:enumeration value="US$/MWh"/>
<xsd:enumeration value="FACTOR"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="systemType">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="OASIS"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="schedClassType">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="P"/>
<xsd:enumeration value="R"/>
<xsd:enumeration value="F"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="statusType">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Data_Transfer_Procedure_Initiated"/>
<xsd:enumeration value="Valid"/>
<xsd:enumeration value="Obsolete"/>
<xsd:enumeration value="Data_Transfer_Succesful"/>
<xsd:enumeration value="Push_Failed"/>
<xsd:enumeration value="Forced_Termination"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="timeZoneType">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="PPT"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="uomType">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="MW"/>
<xsd:enumeration value="MWh"/>
<xsd:enumeration value="US$"/>
<xsd:enumeration value="%"/>
<xsd:enumeration value="INTEGER"/>
<xsd:enumeration value="FLAG"/>
<xsd:enumeration value="$/mmBTU"/>
<xsd:enumeration value="$/lb"/>
<xsd:enumeration value="US$/MW"/>
<xsd:enumeration value="US$/MWh"/>
<xsd:enumeration value="FACTOR"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:element name="ORGANIZATION">
<xsd:complexType mixed="true">
<xsd:choice minOccurs="0" maxOccurs="unbounded">
<xsd:element name="REPORT_ITEM">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="HEADER">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="REPORT" type="reportType"/>
<xsd:element name="SYSTEM" type="systemType"/>
<xsd:element name="TZ" type="timeZoneType"/>
<xsd:element name="MKT_TYPE" type="marketType" minOccurs="0"/>
<xsd:element name="SCHED_CLASS" type="schedClassType" minOccurs="0"/>
<xsd:element name="UOM" type="uomType" minOccurs="0"/>
<xsd:element name="INTERVAL">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="BEGINNING"/>
<xsd:enumeration value="ENDING"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="SEC_PER_INTERVAL" type="xsd:integer"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="DATA" maxOccurs="unbounded">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="DATA_ITEM" type="xsd:string" />
<xsd:element name="SOURCE" type="xsd:string" minOccurs="0"/>
<xsd:element name="SINK" type="xsd:string" minOccurs="0"/>
<xsd:element name="RESOURCE_NAME" type="xsd:string" minOccurs="0"/>
<xsd:element name="OPR_DATE" type="xsd:date" minOccurs="0"/>
<xsd:element name="BEGIN_DATE" type="xsd:date" minOccurs="0"/>
<xsd:element name="END_DATE" type="xsd:date" minOccurs="0"/>
<xsd:element name="BEGIN_HE" type="xsd:integer" minOccurs="0"/>
<xsd:element name="END_HE" type="xsd:integer" minOccurs="0"/>
<xsd:element name="LINE_RATINGS" type="xsd:string" minOccurs="0"/>
<xsd:element name="EQUIPMENT_OUTAGE" type="xsd:string" minOccurs="0"/>
<xsd:element name="NOTES" type="xsd:string" minOccurs="0"/>
<xsd:element name="INTERVAL_NUM" type="xsd:integer" minOccurs="0"/>
<xsd:element name="VALUE" type="xsd:double" minOccurs="0"/>
<xsd:element name="SVALUE" type="xsd:string" minOccurs="0"/>
<xsd:element name="STATUS_TYPE" type="xsd:string" minOccurs="0"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="ATLS_ITEM">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="ATLS_HEADER">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="REPORT" type="reportType"/>
<xsd:element name="SYSTEM" type="systemType"/>
<xsd:element name="TZ" type="timeZoneType"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="ATLS_DATA" maxOccurs="unbounded">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="PUB_DATE" type="xsd:date" minOccurs="0"/>
<xsd:element name="PUB_TIME" type="xsd:time" minOccurs="0"/>
<xsd:element name="PUB_TYPE" type="xsd:string" minOccurs="0"/>
<xsd:element name="MKT_TYPE" type="marketType" minOccurs="0"/>
<xsd:element name="OPR_DATE" type="xsd:date" minOccurs="0"/>
<xsd:element name="INTERVAL" type="xsd:string" minOccurs="0"/>
<xsd:element name="SEC_PER_INTERVAL" type="xsd:integer" minOccurs="0"/>
<xsd:element name="INTERVAL_NUM" type="xsd:integer" minOccurs="0"/>
<xsd:element name="OPR_HR" type="xsd:integer" minOccurs="0"/>
<xsd:element name="OPR_MIN" type="xsd:integer" minOccurs="0"/>
<xsd:element name="VS_NUM" type="xsd:integer" minOccurs="0"/>
<xsd:element name="PUB_INTERVAL" type="xsd:string" minOccurs="0"/>
<xsd:element name="STND_PUB_TIME" type="xsd:string" minOccurs="0"/>
<xsd:element name="BRANCH_GRP" type="xsd:string" minOccurs="0"/>
<xsd:element name="BRANCH_CODE" type="xsd:string" minOccurs="0"/>
<xsd:element name="SUFFIX_ID" type="xsd:string" minOccurs="0"/>
<xsd:element name="LOAD_ID" type="xsd:string" minOccurs="0"/>
<xsd:element name="UNIT_ID" type="xsd:string" minOccurs="0"/>
<xsd:element name="UDC_AREA" type="xsd:string" minOccurs="0"/>
<xsd:element name="EXT_DMD_ZN" type="xsd:string" minOccurs="0"/>
<xsd:element name="CNGS_ZONE" type="xsd:string" minOccurs="0"/>
<xsd:element name="DEMAND_ZONE" type="xsd:string" minOccurs="0"/>
<xsd:element name="LOAD_GRP" type="xsd:string" minOccurs="0"/>
<xsd:element name="CONG_ZONE" type="xsd:string" minOccurs="0"/>
<xsd:element name="CNGS_ZONE_FROM" type="xsd:string" minOccurs="0"/>
<xsd:element name="CNGS_ZONE_TO" type="xsd:string" minOccurs="0"/>
<xsd:element name="INTL_CONT_AREA" type="xsd:string" minOccurs="0"/>
<xsd:element name="ACT_FIELD" type="xsd:string" minOccurs="0"/>
<xsd:element name="TIE_POINT" type="xsd:string" minOccurs="0"/>
<xsd:element name="ERR_CODE" type="xsd:string" minOccurs="0"/>
<xsd:element name="ERR_DESC" type="xsd:string" minOccurs="0"/>
<xsd:element name="SEVERITY_LVL" type="xsd:string" minOccurs="0"/>
<xsd:element name="DESCRIPTION" type="xsd:string" minOccurs="0"/>
<xsd:element name="STATUS" type="statusType" minOccurs="0"/>
<xsd:element name="COMMENTS" type="xsd:string" minOccurs="0"/>
<xsd:element name="RPT_GRP" type="xsd:string" minOccurs="0"/>
<xsd:element name="EFFECTIVE_DATE" type="xsd:string" minOccurs="0"/>
<xsd:element name="REF_NAME" type="xsd:string" minOccurs="0"/>
<xsd:element name="UPDATE_DATE" type="xsd:date" minOccurs="0"/>
<xsd:element name="OLD_SECTION" type="xsd:string" minOccurs="0"/>
<xsd:element name="OLD_VIEW" type="xsd:string" minOccurs="0"/>
<xsd:element name="OLD_SUBVIEW" type="xsd:string" minOccurs="0"/>
<xsd:element name="OLD_RPT_NAME" type="xsd:string" minOccurs="0"/>
<xsd:element name="OLD_EFF_DATE" type="xsd:string" minOccurs="0"/>
<xsd:element name="OLD_TEMPLATE_NAME" type="xsd:string" minOccurs="0"/>
<xsd:element name="OLD_TEMPLATE_FIELD" type="xsd:string" minOccurs="0"/>
<xsd:element name="TAB_LOC" type="xsd:string" minOccurs="0"/>
<xsd:element name="SCH_CLASS" type="xsd:string" minOccurs="0"/>
<xsd:element name="RPT_NAME" type="xsd:string" minOccurs="0"/>
<xsd:element name="RPT_FLD_NAME" type="xsd:string" minOccurs="0"/>
<xsd:element name="XML_RPT_NAME" type="xsd:string" minOccurs="0"/>
<xsd:element name="XML_DATA_ITEM" type="xsd:string" minOccurs="0"/>
<xsd:element name="RPT_GRP" type="xsd:string" minOccurs="0"/>
<xsd:element name="MAT_COMMENTS" type="xsd:string" minOccurs="0"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="DISCLAIMER_ITEM">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="DISCLAIMER" type="xsd:string"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="ERROR">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="ERR_CODE" type="xsd:string" minOccurs="0"/>
<xsd:element name="ERR_DESC" type="xsd:string" minOccurs="0"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:choice>
</xsd:complexType>
</xsd:element>
</xsd:schema>
--------------------------------------------------------------------------------------
Looking at the resultant schema in Enterprise Manager I see it created the table called ORGANIZATION621_TAB, so I try to insert the following document:
--------------------------------------------------------------------------------------
<?xml version="1.0" encoding="utf-8"?><ORGANIZATION xmlns:xsi="http://www.w3.org/2000/10/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://oasis.caiso.com/oasisv003.xsd">CAISO
<REPORT_ITEM><HEADER><REPORT>SLD_LOAD_MW</REPORT><SYSTEM>OASIS</SYSTEM><TZ>PPT</TZ><UOM>MW</UOM><INTERVAL>ENDING</INTERVAL><SEC_PER_INTERVAL>3600</SEC_PER_INTERVAL></HEADER><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>1</INTERVAL_NUM><VALUE>24993</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>2</INTERVAL_NUM><VALUE>24363</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>3</INTERVAL_NUM><VALUE>23747</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>4</INTERVAL_NUM><VALUE>23690</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>5</INTERVAL_NUM><VALUE>24419</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>6</INTERVAL_NUM><VALUE>25700</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>7</INTERVAL_NUM><VALUE>27046</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>8</INTERVAL_NUM><VALUE>29120</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>9</INTERVAL_NUM><VALUE>30923</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>10</INTERVAL_NUM><VALUE>32552</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>11</INTERVAL_NUM><VALUE>33851</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>12</INTERVAL_NUM><VALUE>34339</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>13</INTERVAL_NUM><VALUE>35001</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>14</INTERVAL_NUM><VALUE>35859</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>15</INTERVAL_NUM><VALUE>36486</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>16</INTERVAL_NUM><VALUE>36942</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>17</INTERVAL_NUM><VALUE>36851</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>18</INTERVAL_NUM><VALUE>35942</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>19</INTERVAL_NUM><VALUE>34624</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>20</INTERVAL_NUM><VALUE>33819</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>21</INTERVAL_NUM><VALUE>34556</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>22</INTERVAL_NUM><VALUE>32288</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>23</INTERVAL_NUM><VALUE>29244</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>24</INTERVAL_NUM><VALUE>26397</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_ACTUAL_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>25</INTERVAL_NUM><VALUE/></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>1</INTERVAL_NUM><VALUE>26606</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>2</INTERVAL_NUM><VALUE>25761</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>3</INTERVAL_NUM><VALUE>25265</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>4</INTERVAL_NUM><VALUE>25167</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>5</INTERVAL_NUM><VALUE>25815</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>6</INTERVAL_NUM><VALUE>27375</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>7</INTERVAL_NUM><VALUE>29239</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>8</INTERVAL_NUM><VALUE>31243</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>9</INTERVAL_NUM><VALUE>32785</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>10</INTERVAL_NUM><VALUE>34098</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>11</INTERVAL_NUM><VALUE>35155</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>12</INTERVAL_NUM><VALUE>35573</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>13</INTERVAL_NUM><VALUE>36171</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>14</INTERVAL_NUM><VALUE>37063</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>15</INTERVAL_NUM><VALUE>37656</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>16</INTERVAL_NUM><VALUE>37848</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>17</INTERVAL_NUM><VALUE>37561</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>18</INTERVAL_NUM><VALUE>36677</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>19</INTERVAL_NUM><VALUE>35331</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>20</INTERVAL_NUM><VALUE>35088</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>21</INTERVAL_NUM><VALUE>35546</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>22</INTERVAL_NUM><VALUE>33272</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>23</INTERVAL_NUM><VALUE>30390</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>24</INTERVAL_NUM><VALUE>28063</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_2DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>25</INTERVAL_NUM><VALUE/></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>1</INTERVAL_NUM><VALUE>26738</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>2</INTERVAL_NUM><VALUE>25857</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>3</INTERVAL_NUM><VALUE>25266</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>4</INTERVAL_NUM><VALUE>25103</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>5</INTERVAL_NUM><VALUE>25786</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>6</INTERVAL_NUM><VALUE>27284</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>7</INTERVAL_NUM><VALUE>28893</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>8</INTERVAL_NUM><VALUE>30861</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>9</INTERVAL_NUM><VALUE>32558</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>10</INTERVAL_NUM><VALUE>34077</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>11</INTERVAL_NUM><VALUE>35335</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>12</INTERVAL_NUM><VALUE>35894</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>13</INTERVAL_NUM><VALUE>36585</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>14</INTERVAL_NUM><VALUE>37511</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>15</INTERVAL_NUM><VALUE>38099</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>16</INTERVAL_NUM><VALUE>38190</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>17</INTERVAL_NUM><VALUE>37682</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>18</INTERVAL_NUM><VALUE>36535</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>19</INTERVAL_NUM><VALUE>35121</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>20</INTERVAL_NUM><VALUE>34828</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>21</INTERVAL_NUM><VALUE>35178</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>22</INTERVAL_NUM><VALUE>32954</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>23</INTERVAL_NUM><VALUE>30038</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>24</INTERVAL_NUM><VALUE>27946</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_1DA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>25</INTERVAL_NUM><VALUE/></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>1</INTERVAL_NUM><VALUE>25568</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>2</INTERVAL_NUM><VALUE>24734</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>3</INTERVAL_NUM><VALUE>24256</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>4</INTERVAL_NUM><VALUE>23977</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>5</INTERVAL_NUM><VALUE>24836</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>6</INTERVAL_NUM><VALUE>26419</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>7</INTERVAL_NUM><VALUE>28029</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>8</INTERVAL_NUM><VALUE>30072</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>9</INTERVAL_NUM><VALUE>31799</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>10</INTERVAL_NUM><VALUE>33286</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>11</INTERVAL_NUM><VALUE>34524</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>12</INTERVAL_NUM><VALUE>34826</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>13</INTERVAL_NUM><VALUE>35503</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>14</INTERVAL_NUM><VALUE>36247</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>15</INTERVAL_NUM><VALUE>36809</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>16</INTERVAL_NUM><VALUE>37004</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>17</INTERVAL_NUM><VALUE>36658</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>18</INTERVAL_NUM><VALUE>35698</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>19</INTERVAL_NUM><VALUE>34536</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>20</INTERVAL_NUM><VALUE>34320</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>21</INTERVAL_NUM><VALUE>34678</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>22</INTERVAL_NUM><VALUE>32341</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>23</INTERVAL_NUM><VALUE>29423</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>24</INTERVAL_NUM><VALUE>26784</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_FCST_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>25</INTERVAL_NUM><VALUE/></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>1</INTERVAL_NUM><VALUE>25936</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>2</INTERVAL_NUM><VALUE>24928</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>3</INTERVAL_NUM><VALUE>24219</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>4</INTERVAL_NUM><VALUE>24139</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>5</INTERVAL_NUM><VALUE>24284</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>6</INTERVAL_NUM><VALUE>25416</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>7</INTERVAL_NUM><VALUE>27260</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>8</INTERVAL_NUM><VALUE>29454</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>9</INTERVAL_NUM><VALUE>31273</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>10</INTERVAL_NUM><VALUE>32785</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>11</INTERVAL_NUM><VALUE>34425</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>12</INTERVAL_NUM><VALUE>35267</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>13</INTERVAL_NUM><VALUE>35346</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>14</INTERVAL_NUM><VALUE>36026</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>15</INTERVAL_NUM><VALUE>36682</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>16</INTERVAL_NUM><VALUE>36690</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>17</INTERVAL_NUM><VALUE>36767</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>18</INTERVAL_NUM><VALUE>35770</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>19</INTERVAL_NUM><VALUE>34898</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>20</INTERVAL_NUM><VALUE>34220</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>21</INTERVAL_NUM><VALUE>34358</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>22</INTERVAL_NUM><VALUE>33070</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>23</INTERVAL_NUM><VALUE>29197</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>24</INTERVAL_NUM><VALUE>26820</VALUE></DATA><DATA><DATA_ITEM>LOAD_SYS_SCHD_HA_MW</DATA_ITEM><OPR_DATE>2006-08-01</OPR_DATE><INTERVAL_NUM>25</INTERVAL_NUM><VALUE/></DATA></REPORT_ITEM><DISCLAIMER_ITEM><DISCLAIMER>The contents of these pages are subject to change without notice. Decisions based on information contained within the California ISO's web site are the visitor's sole responsibility.</DISCLAIMER></DISCLAIMER_ITEM></ORGANIZATION>
--------------------------------------------------------------------------------------
using the following sql command:
--------------------------------------------------------------------------------------
insert into "ORGANIZATION621_TAB" values (XMLType(bfilename('OASIS_SCHEMA_DIR', '20060801_20060801_SLD_LOAD_GW_N_N.xml'),
nls_charset_id('AL32UTF8')));
--------------------------------------------------------------------------------------
but it returns the following error:
--------------------------------------------------------------------------------------
ERROR at line 1:
ORA-30937: No schema definition for 'ORGANIZATION' (namespace '') in parent '/'
--------------------------------------------------------------------------------------
Both the schema and the document are generated by an outside agency, and my goal is to insert the document unmodified, so I am assuming I must modify the schema, so any suggestions in that area would be greatly appreciated!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 7 2006
Added on Oct 5 2006
#performance-availability, #xml-db
3 comments
684 views