XMLTYPE datatypw [message #599685] |
Mon, 28 October 2013 04:05 |
ashish_sun123
Messages: 52 Registered: November 2010 Location: Bangalore
|
Member |
|
|
I am trying to insert the following values in a table called as inf_content
The table INF_CONTENT has following two cols
( REQUEST_ID NUMBER(10,0) ,
FLTER_SET_XML "SYS"."XMLTYPE" NOT NULL ENABLE);
===========================================================================================
INSERT INTO inf_content
(request_id,
filter_set_xml);
VALUES (721,
XMLTYPE('<DataSubscriber Name="OriginalInvoiceJournal"><BusinessComponent Name="InvoiceRevisionLinear"><FilterGroup Name="InvoiceDetails"><Filter Name="InvoicingAgency" Id="882" DisplayValue="***ALL VALUES***">***ALL VALUES***</Filter><Filter Name="RevenueCode" Id="888" DisplayValue="Cash">1','3</Filter><Filter Name="RevenueCode" Id="888" DisplayValue="Trade">2</Filter><Filter Name="Advertiser" Id="880" DisplayValue="***ALL VALUES***">***ALL VALUES***</Filter><Filter Name="Network" Id="878" DisplayValue="MTV">BB62D714-4F46-1DA1-E040-1EACC1D872F3</Filter><Filter Name="Network" Id="878" DisplayValue="CMDY">BB62D714-4F56-1DA1-E040-1EACC1D872F3</Filter><Filter Name="Network" Id="878" DisplayValue="CMT">BB62D714-4F4F-1DA1-E040-1EACC1D872F3</Filter><Filter Name="Network" Id="878" DisplayValue="VH1">BB62D714-4F48-1DA1-E040-1EACC1D872F3</Filter><Filter Name="AccountExecutive" Id="886" DisplayValue="***ALL VALUES***">***ALL VALUES***</Filter><Filter Name="BuyType" Id="884" DisplayValue="***ALL VALUES***">***ALL VALUES***</Filter><Filter Name="OnlyDisplayEDIInvoices" Id="892" DisplayValue="Unchecked">N</Filter><Filter Name="MarketTypeDeal" Id="890" DisplayValue="Upfront">UPFRONT</Filter><Filter Name="MarketTypeDeal" Id="890" DisplayValue="Other">NEITHER</Filter><Filter Name="MarketTypeDeal" Id="890" DisplayValue="Scatter">SCATTER</Filter></FilterGroup><FilterGroup Name="InvoiceIntervalDates"><Filter Name="IntervalStartDate" Id="870" DisplayValue="***ALL VALUES***">***ALL VALUES***</Filter><Filter Name="IntervalEndDate" Id="872" DisplayValue="***ALL VALUES***">***ALL VALUES***</Filter></FilterGroup><FilterGroup Name="InvoiceIntervalTypes"><Filter Name="InvoiceInterval" Id="868" DisplayValue="***ALL VALUES***">***ALL VALUES***</Filter></FilterGroup><FilterGroup Name="ReportByDateRange"><Filter Name="DateRangeStartDate" Id="874" DisplayValue="8/29/2011">29-Aug-2011</Filter><Filter Name="DateRangeEndDate" Id="876" DisplayValue="9/25/2011">25-Sep-2011</Filter></FilterGroup></BusinessComponent><BusinessComponent Name="InvoiceRevisionNonlinear"><FilterGroup Name="InvoiceDetails"><Filter Name="InvoicingAgency" Id="883" DisplayValue="***ALL VALUES***">***ALL VALUES***</Filter><Filter Name="RevenueCode" Id="889" DisplayValue="Cash">1','3</Filter><Filter Name="RevenueCode" Id="889" DisplayValue="Trade">2</Filter><Filter Name="Advertiser" Id="881" DisplayValue="***ALL VALUES***">***ALL VALUES***</Filter><Filter Name="Network" Id="879" DisplayValue="MTV">BB62D714-4F46-1DA1-E040-1EACC1D872F3</Filter><Filter Name="Network" Id="879" DisplayValue="CMDY">BB62D714-4F56-1DA1-E040-1EACC1D872F3</Filter><Filter Name="Network" Id="879" DisplayValue="CMT">BB62D714-4F4F-1DA1-E040-1EACC1D872F3</Filter><Filter Name="Network" Id="879" DisplayValue="VH1">BB62D714-4F48-1DA1-E040-1EACC1D872F3</Filter><Filter Name="AccountExecutive" Id="887" DisplayValue="***ALL VALUES***">***ALL VALUES***</Filter><Filter Name="BuyType" Id="885" DisplayValue="***ALL VALUES***">***ALL VALUES***</Filter><Filter Name="OnlyDisplayEDIInvoices" Id="893" DisplayValue="Unchecked">N</Filter><Filter Name="MarketTypeDeal" Id="891" DisplayValue="Upfront">UPFRONT</Filter><Filter Name="MarketTypeDeal" Id="891" DisplayValue="Other">NEITHER</Filter><Filter Name="MarketTypeDeal" Id="891" DisplayValue="Scatter">SCATTER</Filter></FilterGroup><FilterGroup Name="InvoiceIntervalDates"><Filter Name="IntervalStartDate" Id="871" DisplayValue="***ALL VALUES***">***ALL VALUES***</Filter><Filter Name="IntervalEndDate" Id="873" DisplayValue="***ALL VALUES***">***ALL VALUES***</Filter></FilterGroup><FilterGroup Name="InvoiceIntervalTypes"><Filter Name="InvoiceInterval" Id="869" DisplayValue="***ALL VALUES***">***ALL VALUES***</Filter></FilterGroup><FilterGroup Name="ReportByDateRange"><Filter Name="DateRangeStartDate" Id="875" DisplayValue="8/29/2011">29-Aug-2011</Filter><Filter Name="DateRangeEndDate" Id="877" DisplayValue="9/25/2011">25-Sep-2011</Filter></FilterGroup></BusinessComponent><DisplayOptions><DisplayOption Name="InvoiceIntervalSelector" Id="306" DisplayValue="Date range">DateRange</DisplayOption><DisplayOption Name="IncludeUnits" Id="309" DisplayValue="Checked">Y</DisplayOption><DisplayOption Name="IncludeNonLinearItems" Id="310" DisplayValue="Unchecked">N</DisplayOption><DisplayOption Name="SummaryCombinedTotals" Id="311" DisplayValue="Unchecked">N</DisplayOption><DisplayOption Name="SummaryByRateClassByBuyType" Id="312" DisplayValue="Checked">Y</DisplayOption><DisplayOption Name="SummaryByNonLinearPlatform" Id="313" DisplayValue=""></DisplayOption><DisplayOption Name="SummaryByNonLinearPlatform_ExcludedFromRevenue" Id="314" DisplayValue=""></DisplayOption><DisplayOption Name="DetailAllRateClasses" Id="315" DisplayValue="Checked">Y</DisplayOption><DisplayOption Name="DetailIndividualRateClasses" Id="316" DisplayValue="Checked">Y</DisplayOption><DisplayOption Name="DetailNonLinearPlatform" Id="317" DisplayValue=""></DisplayOption><DisplayOption Name="DetailNonLinearPlatform_ExcludedFromRevenue" Id="318" DisplayValue=""></DisplayOption><DisplayOption Name="JournalReportTotals" Id="319" DisplayValue="Individual Network">Individual</DisplayOption><DisplayOption Name="JournalReportSortBy" Id="320" DisplayValue="Agency, Advertiser, Brand, Invoice Number">AgcyAdvBrandInvNum</DisplayOption><DisplayOption Name="ConsumerFormat" Id="307" DisplayValue="Report viewer">Type=SSRS;Path=OriginalInvoiceJournal.rdl;Format=ssrs;Id=45</DisplayOption><DisplayOption Name="FilterPage" Id="308" DisplayValue="Suppress filter page">S</DisplayOption></DisplayOptions></DataSubscriber>'));
I am getting the error:
Error:
SQL Error: ORA-06553: PLS-307: too many declarations of 'XMLTYPE' match this call
Please advice what to do?
|
|
|
|
|
|
|
Re: XMLTYPE datatypw [message #599755 is a reply to message #599752] |
Mon, 28 October 2013 11:41 |
_jum
Messages: 577 Registered: February 2008
|
Senior Member |
|
|
You can try what ORACLE "says" very easy:
SELECT XMLTYPE ('<Filter Name="RevenueCode" Id="888" DisplayValue="Cash">1','3</Filter>') FROM dual;
SELECT XMLTYPE ('<Filter Name="RevenueCode" Id="888" DisplayValue="Cash">1,3</Filter>') FROM dual;
SELECT XMLTYPE ('<Filter Name="RevenueCode" Id="888" DisplayValue="Cash">1'',''3</Filter>') FROM dual;
|
|
|