- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, November 08, 2003 5:11 AM
Subject: RE: Use stored procedure for insert questions
Based on the configuration of the 'insert-procedure' descriptor that you
provided earlier, here's the syntax
Hello All
I currently trying to use the cvs version of ojb 1.0 with an Oracle 9i
Database and I have a few problem with stored procedure and sequences:
1: I want to Stored procedure for insert some rows.
The stored procedure return the id ( primary key ) of the row.But i don't
know wich sequence
will be placed in the 'id'
attribute on the 'Twtinstances' class.
HTH
Ron Gallagher
Atlanta, GA
[EMAIL PROTECTED]
-Original Message-
From: Thierry Hanot [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 10:20 AM
To: 'OJB Users List'
Subject: Use stored procedure for insert questions
Hello
]
Subject: RE: Use stored procedure for insert questions
Thierry --
You shouldn't need to use a sequence manager since the SP is assigning the
id. Based on the configuration of the 'insert-procedure' descriptor, the
first argument to the sp will be defined as either 'OUT' or 'IN OUT'. In
either
,
aDESCRIPTION,
aDATASYNC,
aCONFIGID);
END;
HTH
Ron Gallagher
Atlanta, GA
[EMAIL PROTECTED]
-Original Message-
From: Thierry Hanot [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 10:58 AM
To: 'OJB Users List'
Subject: RE: Use stored procedure for insert questions
Thanks