Devart Forums

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 ??

We have sent a workaround to the e-mail you have provided in your profile.