Tools I Used Today

Oracle Enterprise Mgr.
Tweaked the CareerPathSalesPositionNumber Procedure to return a Number instead of a Cursor Reference so now the declaration looks like this in the Package Declaration:

PROCEDURE CareerPathSalesPositionNumber(InParm IN NUMBER, OutParm OUT NUMBER);

In the package body the OPEN CURSOR FOR SELECT... is replaced with A SELECT INTO which looks something like:

SELECT DISTINCT
columnx INTO outParm
FROM
tablex
WHERE ....


VS .net 2003
Grabbing the return value is slightly different than using the Cursor Reference to fill a DataTable:

cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("InParm", OracleType.Number).Value = iInParm;

cmd.Parameters.Add("OutParm", OracleType.Number).Direction = ParameterDirection.Output;

cmd.ExecuteNonQuery();

iOutParmVal = Convert.ToInt32(cmd.Parameters["OutParm"].Value);



SQL+Plus Worksheet

Finished slogging test data into the DB. What a pita!