#inserted

ORA-53002: document name “string” already inserted

文档解释ORA-53002:documentname“string”alreadyinsertedCause:Thespecifieddocumentnamewasfoundintherepository.Action:Specifyauniquedocumentnameandtryagain....

ORA-31057: Display Name of the element being inserted is null

文档解释ORA-31057:DisplayNameoftheelementbeinginsertedisnullCause:TheDisplayNameoftheelementwhichisbeinginsertedintotheRESOURCE_VIEWisnullAction:SpecifytheDisplayNa...
IT技术学习 ·2023-07-27

ORA-53021: cannot insert a rule or macro string that was already inserted

文档解释ORA-53021:cannotinsertaruleormacrostringthatwasalreadyinsertedCause:Therulesormacrosexistedintherepository.Action:Insertanewruleormacro.这是ORACLE报出的一个错误,表示无法...

ORA-31056: The document being inserted does not conform to string

文档解释ORA-31056:ThedocumentbeinginserteddoesnotconformtostringCause:TheXMLTypeelementbeinginsertedintotheRESOURCE_VIEWdoesnotconformtothespecifiedSchemaAction:Ins...

ORA-14409: inserted partition key is outside specified subpartition

文档解释ORA-14409:insertedpartitionkeyisoutsidespecifiedsubpartitionCause:theconcatenatedpartitionkeyofaninsertedrecordisoutsidetherangesofthetwoconcatenatedsubpart...

ORA-14400: inserted partition key does not map to any partition

文档解释ORA-14400:insertedpartitionkeydoesnotmaptoanypartitionCause:Anattemptwasmadetoinsertarecordinto,aRangeorCompositeRangeobject,withaconcatenatedpartitionkeyth...

ORA-31055: A null XMLType element cannot be inserted into RESOURCE_VIEW

文档解释ORA-31055:AnullXMLTypeelementcannotbeinsertedintoRESOURCE_VIEWCause:TheelementwhichisbeinginsertedintotheRESOURCE_VIEWisNULLAction:Specifyanon-nullXMLTypeel...

ORA-14401: inserted partition key is outside specified partition

文档解释ORA-14401:insertedpartitionkeyisoutsidespecifiedpartitionCause:theconcatenatedpartitionkeyofaninsertedrecordisoutsidetherangesofthetwoconcatenatedpartitionb...

ORA-31167: XML nodes over 64K in size cannot be inserted

文档解释ORA-31167:XMLnodesover64KinsizecannotbeinsertedCause:AnattemptwasmadetoinsertanXMLTextNodewithasizegreaterthan64K.Thisisnotsupported.Action:Createtextnodesu...
IT技术学习 ·2023-07-09

ORA-03129: the next piece to be inserted is required

文档解释ORA-03129:thenextpiecetobeinsertedisrequiredCause:Theapplicationperformedapiecewisebindonacolumn.Action:Providethenextpieceofthisbindvariable.ORA-03129:下一个要...
IT技术学习 ·2023-07-09

ORA-01401: inserted value too large for column

文档解释ORA-01401:insertedvaluetoolargeforcolumnCause:Thevalueinsertedwastoolargeforthegivencolumn.Action:Donotinsertavaluegreaterthanwhatthecolumncanhold.这是Oracle数...

ORA-13375: the layer is of type [string] while geometry inserted has type [string]

文档解释ORA-13375:thelayerisoftype[string]whilegeometryinsertedhastype[string]Cause:Thelayerhasatypethatisdifferentorinconsistentwiththetypeofthecurrentgeometry.Act...

SQL 带有output、inserted、deleted

因需求的关系需要将修改的值返回,故查了些资料发现了OUTPUT这个好东西,现记录下来以防以后忘记 使用例子: 1.对于INSERT,可以引用inserted表以查询新行的属性.   insertinto[表名](a)OUTPUTInserted.avalues('a')...