This question is locked. New answers and comments are not allowed.
Hi all,
I have proplem. This is my code:
string strQuery = "SELECT mmsi,nvl(imo,0),nvl(name,''),nvl(callsign,''),country_id,nvl(type_id,0),nvl(length,0),nvl(width,0),nvl(draugth,0),cog,sog,rot, longitude,latitude,nvl(status_id,0),nvl(heading,0),eta,nvl(destination,''),last_received " +
"FROM table(ais_vessel_pkg.get_vessels(P_FIRST=>?,P_LAST=>?,P_LONG_FIRST=>?, P_LONG_LAST=>?,P_MMSIS=>?,P_SOURCE=>?))";
long lAgentID = 0;
if (!string.IsNullOrEmpty(agentID)) {
lAgentID = Convert.ToInt64(agentID);
}
IQuery query = scope.GetSqlQuery(strQuery, null, "DATE p_first,DATE p_last ,number p_long_first,number p_long_last,VARCHAR2 p_mmsis,number p_source");
var queryResult = query.Execute(first, last, 0, 0, mmsis, lAgentID);
foreach (object[] obj in queryResult)
{
......
}
But it is to stand forever line "foreach (object[] obj in queryResult) ". Please !, help me
"
I have proplem. This is my code:
string strQuery = "SELECT mmsi,nvl(imo,0),nvl(name,''),nvl(callsign,''),country_id,nvl(type_id,0),nvl(length,0),nvl(width,0),nvl(draugth,0),cog,sog,rot, longitude,latitude,nvl(status_id,0),nvl(heading,0),eta,nvl(destination,''),last_received " +
"FROM table(ais_vessel_pkg.get_vessels(P_FIRST=>?,P_LAST=>?,P_LONG_FIRST=>?, P_LONG_LAST=>?,P_MMSIS=>?,P_SOURCE=>?))";
long lAgentID = 0;
if (!string.IsNullOrEmpty(agentID)) {
lAgentID = Convert.ToInt64(agentID);
}
IQuery query = scope.GetSqlQuery(strQuery, null, "DATE p_first,DATE p_last ,number p_long_first,number p_long_last,VARCHAR2 p_mmsis,number p_source");
var queryResult = query.Execute(first, last, 0, 0, mmsis, lAgentID);
foreach (object[] obj in queryResult)
{
......
}
But it is to stand forever line "foreach (object[] obj in queryResult) ". Please !, help me
"