Thanks Jiri!!
Where can I add a tracker? I think I find a bug with stored procedures >_>
Or maybe you can help me.
I written another stored procedure which receive 3 in parameters and returns
2 parameters:
SET TERM ^ ;
CREATE PROCEDURE DEPART_AGREGAR_NUEVO(
CODIGO VARCHAR(20) CHARACTER SET UTF8,
NOMBRE_DEPARTAMENTO TYPE OF VARCHAR_LARGO,
USUARIO_REGISTRO TYPE OF USUARIO)
RETURNS(
ROWS_AFFECTED INTEGER,
ID TYPE OF UUID)
AS
DECLARE VARIABLE CONTINUAR SMALLINT DEFAULT 1;
BEGIN
ROWS_AFFECTED = 0;
IF( (SELECT COUNT(*) FROM DEPARTAMENTO WHERE DEPARTAMENTO.CODIGO = :CODIGO
AND DEPARTAMENTO.LOGIC_DELETED = 0) > 0) THEN
CONTINUAR = 0;
IF( CONTINUAR = 1) THEN
BEGIN
INSERT INTO
DEPARTAMENTO(DEPARTAMENTO.CODIGO, DEPARTAMENTO.NOMBRE_DEPARTAMENTO,
DEPARTAMENTO.USUARIO_REGISTRO)
VALUES(:CODIGO, :NOMBRE_DEPARTAMENTO, :USUARIO_REGISTRO);
ID = (SELECT DEPARTAMENTO.DEPART_UUID FROM DEPARTAMENTO
WHERE DEPARTAMENTO.CODIGO = :CODIGO AND
DEPARTAMENTO.NOMBRE_DEPARTAMENTO = :NOMBRE_DEPARTAMENTO
AND
DEPARTAMENTO.USUARIO_REGISTRO = :USUARIO_REGISTRO AND
DEPARTAMENTO.LOGIC_DELETED =0);
ROWS_AFFECTED = ROW_COUNT;
END
SUSPEND;
END^
SET TERM ; ^
When I add the SP to my EntityModel, I get the five parameters.
I set ROWS_AFFECTED like Rows Affected Parameter,
My problem is with the ID parameter. It displays like a out parameter and I
can't map it to entity Property DEPART_UUID to assign it after insert
(because UUID is generated in the database), Then I erase the parameter in
the .edmx file manually, maybe it's a problem reading the SP from de DB.
That's o.k.
But I wanna know how to retrieve the Id uuid Parameter and assign it. If I
add this parameter in the "Result Column Binding" I get an error.
Thanks for all :D
--
View this message in context:
http://firebird.1100200.n4.nabble.com/EF-4-Error-mapping-UUID-Char-16-to-GUID-for-Stored-Procedure-Input-Parameter-tp3745547p3757427.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Get a FREE DOWNLOAD! and learn more about uberSVN rich system,
user administration capabilities and model configuration. Take
the hassle out of deploying and managing Subversion and the
tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
