Oracle + ModificationFunctionMapping

[McpGza]

Can you provide a small example for modification (eg. insert) stored procedure mapping?

How the insert stored procedure sholud look like? Hogy the msl mapping and ssdl sholud look like?

Please show an example.

[AndreyR]

Here is a simple example.
Stored procedure Dept_Insert looks like:

Code: Select all

CREATE OR REPLACE PROCEDURE SCOTT.Dept_Insert (
	Pdeptno NUMBER,
	Pdname VARCHAR, 
	Ploc VARCHAR )
IS 
BEGIN
	INSERT INTO Dept(Deptno, Dname, Loc) VALUES (Pdeptno, Pdname, Ploc);
END;

The Modification Function Mapping looks like:

Code: Select all

              
                
                  
                  
                  
...
              

The SSDL part looks like:

Code: Select all

[McpGza]

Here is a simple example.
Stored procedure Dept_Insert looks like:
...

Thank you, but the insert needs result binding for server generated indentity columns. I dont see the result binding in your example, how it works?

[AndreyR]

There is no easy way to handle such situation.
I have sent an email with some hints to the address you provided in your profile.

[McpGza]

There is no easy way to handle such situation.

Yes, we noticed there is no easy way

Thank you for very fast response, we will try your suggestion soon.
Regards,
Geza

[andregur]

Please publish information about result binding for server generated indentity columns from insert stored procedure.
I think that such information is necessary for many developers.

[AndreyR]

We have sent you a workaround.

[Ido Flatow]

We have sent you a workaround.

Can you please publish an article that describe how to do it?

Thanks,
Ido.

[AndreyR]

We have sent you a workaround.

[Ido Flatow]

When you create an eager load with .Include() on more than one entity, the generated query creates a sql part to select null values, and because it created TO_BLOB(NULL) parts instead of HEXTORAW(0) part and this causes exceptions because the union statement tries to union different types of columns.

I tried changing the conceptual type to GUID because I read somewhere that GUID is translated into RAW, but then I got an error message because the conceptual field of the GUID cannot be mapped to a function parameter of type REF CURSOR.

Any workaround for this problem?

Ido.

[AndreyR]

Thank you for the report, we are investigating the problem.
I will let you know about the results.

[ToxicAtom]

Is it possible to see the work around please?

Thank you

[AndreyR]

We have sent you the workaround.

[ies]

i want to see the work around too, can you send to me please?

thanks,
________
Peter Sutcliffe (Race Driver)

[AndreyR]

We have sent you the workaround too.