Hello.

I now want to convert my project to nhibernate3 from ado.net and have
small problem.
I use Oracle DB and generate id with stored procedure.

Exemple:

FUNCTION GET_AUTO_NUMBER
RETURN NUMBER
IS
n NUMBER;
BEGIN
  SELECT AUTONUM.NEXTVAL*1000 + 1 INTO n FROM DUAL;
  RETURN n;
END GET_AUTO_NUMBER;

and insert ex:
INSERT INTO Comissions (
                                                                ID,
                                                                N_Comission,
                                                                D_Begin_Book,
                                                                D_End_Book,
                                                                D_Begin_Serv,
                                                                D_End_Serv)
                                                        VALUES (
                                                                
MAIN_PKG.GET_AUTO_NUMBER,
                                                                :N_Comission,
                                                                :D_Begin_Book,
                                                                :D_End_Book,
                                                                :D_Begin_Serv,
                                                                :D_End_Serv)

How I can mapping this exemple?
What POID generator should I choose? And how it's written in xml and
fluent?
Or is there another way? I need AUTONUM.NEXTVAL*1000 + 1
Thx for answers.

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en.

Reply via email to