HI ,
We have got a licensed copy for dotConnect for Oracle and we would like to implement a SOA application using Entity Framework with dotConnect provider .
I am trying to returning a primary key using result binding and i am facing below error .
{"Store update, insert, or delete statement affected an unexpected number of rows (0). Entities may have been modified or deleted since entities were loaded. Refresh ObjectStateManager entries."}
Could you please suggest something on this .
Here is the description of table and stored procedure :-
CREATE TABLE TEST.TEST
(
TEST_ID NUMBER,
DETAILS VARCHAR2(72 BYTE) NOT NULL
)
ALTER TABLE TEST.TEST ADD (
CONSTRAINT TEST_PK
PRIMARY KEY
(TEST_ID);
CREATE OR REPLACE PROCEDURE TEST.TEST_Insert
(
p_Details IN "TEST"."DETAILS"%type
)
IS
p_TEST_ID "TEST"."TEST_ID"%type ;
BEGIN
INSERT
INTO "TEST"
(
"TEST_ID",
"DETAILS"
)
VALUES
(
TEST_SEQ.nextval,
p_Details
)Returning "TEST_ID" into p_TEST_ID ;
END ;
In ResultsBinding of Insert for Test i have mapped ollowing .
p_TEST_ID ---> p_TEST_ID
on
Context.SaveChanges() ;
We have tested this with Sql server and it is running smoothly .
i have got the above error .
Please let me know whether you need the code and scripts to reproduce issue .
Is there any faster way to avail support for dotConnect for Oracle ?
Also Wondering a lot why output parameters are not supported here ??