returning into oracle c#

[ace333]

CREATE OR REPLACE PROCEDURE WES_UAT.P_INS_EMAIL
(
param_sendTo IN EMAIL.SENDTO%TYPE,
param_sendFrom IN EMAIL.SENDFROM%TYPE,
param_subject IN EMAIL.SUBJECT%TYPE,
param_format IN EMAIL.BODYFORMAT%TYPE,
param_priority IN EMAIL.PRIORITY%TYPE,
param_body IN EMAIL.EMAILBODY%TYPE,
param_errorEmailAddress IN EMAIL.ERROREMAILADDRESS%TYPE,
param_ccEmailAddress IN EMAIL.CCEMAILADDRESS%TYPE,
param_systemName IN EMAIL.SYSTEMNAME%TYPE
)
IS

BEGIN
INSERT INTO EMAIL(
ID,
SENDTO,
SENDFROM,
SUBJECT,
EMAILBODY,
BODYFORMAT,
PRIORITY,
LASTUPDATED,
PROCESSEDFLAG,
ERROREMAILADDRESS,
CCEMAILADDRESS,
SYSTEMNAME,
INPUTDATE
)
VALUES(
SEQ_EMAIL_ID .NEXTVAL,
param_sendTo,
param_sendFrom,
param_subject,
param_body,
param_format,
param_priority,
SYSDATE,
N,
param_errorEmailAddress,
param_ccEmailAddress,
param_systemName,
SYSDATE
)
returning id into GLOBALS.i
;
END;

This is an oracle stored proc

How do I read the value i from the stored proc from c#, when i do the insert i want to be able to get the id associated with that insert

 

[hrabia]

Declare one more stored procedure parameter as an out parameter for example:
param_ID OUT NUMBER

and then...
RETURNING ID INTO param_ID;

...and then you can read param_ID value in your c# function.