StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POORA-01400 when trying to insert into schema.table.ID
primarykey
Id
11972490
data
AcceptedAnswerId
11973144
AnswerCount
3
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2012-08-15T15:40:34.747
FavoriteCount
1
LastActivityDate
2013-09-05T11:50:08.097
LastEditDate
2012-08-15T19:31:54.760
LastEditorUserId
1574689
OwnerUserId
1574689
ParentId
0
PostTypeId
1
Score
5
ViewCount
3939
LastEditorDisplayName
text
Body
I have a table that stores rejected contract proposals. <pre><code>CREATE TABLE "STATUS_CONTRATO" ( "STC_ID" NUMBER NOT NULL, "CTB_CONTRATO" NUMBER NOT NULL, "STC_DATA" DATE NOT NULL, "STC_OBSERVACAO" VARCHAR2(200) NOT NULL, CONSTRAINT "STATUS_CONTRATO_PK" PRIMARY KEY ( "STC_ID") ENABLE VALIDATE, CONSTRAINT "FK_CONTRATO" FOREIGN KEY ( "CTB_CONTRATO") REFERENCES "CONTRATO" ( CTB_CONTRATO) ON DELETE SET NULL ENABLE VALIDATE) ; </code></pre> (Script generated by Visual Studio 2010) This table has a simple Trigger, where the value of <code>STC_ID</code> is set: <pre><code>TRIGGER "STATUS_CONTRATO_TRIGGER1" BEFORE INSERT ON "STATUS_CONTRATO" FOR EACH ROW when (new.STC_ID = 0) DECLARE BEGIN SELECT SEQ_STATUS_ID.NEXTVAL INTO :NEW.STC_ID FROM DUAL; END; </code></pre> <code>SEQ_STATUS_ID</code> is a simple sequence. Here's my problem: I can successfuly execute this insert in the VS2010 query window: <pre><code>insert into myschema.STATUS_CONTRATO s( s.STC_ID, s.CTB_CONTRATO, s.STC_DATA, s.STC_OBSERVACAO )values( 0, 10, SYSDATE, 'Inserting by hand works' ); </code></pre> But, when I try to insert using EF, I'm getting this exception: <pre><code>System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Oracle.DataAccess.Client.OracleException: ORA-01400: cannot insert NULL into ("MYSCHEMA"."STATUS_CONTRATO"."STC_ID") ORA-06512: at line 4 </code></pre> I'm using this code to insert <pre><code>STATUS_CONTRATO statusContrato = new STATUS_CONTRATO() { STC_ID = 0, CTB_CONTRATO = codContrato, STC_DATA = DateTime.Today, STC_OBSERVACAO = observacao }; ent.STATUS_CONTRATO.AddObject(statusContrato); ent.SaveChanges(); </code></pre> I'm using VS2010, Oracle 11g (CentOS Server), ODP.NET client 11.2.0.3.0 Production, .NET Framework 4.0, EF 4.
Tags
<c#><oracle><entity-framework><ora-01400>
Title
ORA-01400 when trying to insert into schema.table.ID
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USTimoteo Brasil
UserOwnerUserId
1. USTimoteo Brasil
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POORA-01400 when trying to insert into schema.table.ID
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POORA-01400 when trying to insert into schema.table.ID
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.