Imam sledeci problem, pa se nadam da cete mi pomoci da ga resim. Iz .NET aplikacije pozivam izvrsavanje sledeceg koda nad Oracle bazom:
DECLARE temp INT;
BEGIN
SELECT DamDocumentSeq.nextval into temp from dual;
INSERT INTO DamDocument(DocumentID, DocumentTypeID, SiteID, PartnerID, DocumentNumber, PartnerDocumentNumber, ArrivalDate, PartnerDocumentDate, Note, UserID, NotDone, FolderID, Komentar, InheritPermissions, DepartmentID, RowVersion)
VALUES (temp, 16, null, null, '', '', SYSDATE, SYSDATE, '', 101, 0, null, '', 1, null, 1);
INSERT INTO DamDocument16(documentid, A616, A83, A82, A81, A80, A79, A78, A76, A75, A74, A73, A77, RowVersion)
VALUES (temp, '', '124323122', '123123', 333, '987', 'Ne', DATE '2007-06-15', '4564564564', 'fghjjk', DATE '2007-06-15', DATE '2007-06-15', '123456789', 1);
END;
E, sad - kako da u c# kod (dakle, u aplikaciju) vratim vrednost sekvence, tj. vrednost parametra temp? Jasno mi je kako da to uradim u stored proceduri, ali nemam mogucnost kreiranja stored procedure nad bazom.
Hvala!
The important thing is not to stop questioning. Curiosity has its own reason for existing. - Albert Einstein