hi,

In My pro*c code when I am executing Following code its giving perfect results.

EXEC SQL DECLARE count_cursor CURSOR FOR
SELECT * FROM (
SELECT Trade_Count,
Day_Trade_Count
FROM Margin_Balance
WHERE (Account_Id = :accountid) AND
(Account_Reg_Class_Id = :regclassid) AND
(Calculation_Date <= to_date (:calculationdate, 'YYYY-MM-DD')) AND
(Balance_Type = 'Local') AND
(Request_Type = 'Post')
ORDER BY Calculation_Date Desc
) WHERE rownum < 5;

it selects all rows which is right,
but when i replace '5' with variable, its only select first row, can any one tell me why? what is the problem, and what is possible solution

EXEC SQL BEGIN DECLARE SECTION;
int DayTradeBusinessDates;
EXEC SQL END DECLARE SECTION;

DayTradeBusinessDates = 5;

EXEC SQL DECLARE count_cursor CURSOR FOR
SELECT * FROM (
SELECT Trade_Count,
Day_Trade_Count
FROM Margin_Balance
WHERE (Account_Id = :accountid) AND
(Account_Reg_Class_Id = :regclassid) AND
(Calculation_Date <= to_date (:calculationdate, 'YYYY-MM-DD')) AND
(Balance_Type = 'Local') AND
(Request_Type = 'Post')
ORDER BY Calculation_Date Desc
) WHERE rownum < :DayTradeBusinessDates;

this Query returns only one row, that is first row of inner query.

1  out of 1 found this valuable. Do you find this valuable? Do you?