ORA-01036: illegal variable name
401760Aug 19 2003 — edited Aug 20 2003hi,
I m always getting ORA-01036: error when trying to call a storep proc in a package from NET with input date params. can somebody help me on this -please
thanks
my package looks like this:
CREATE OR REPLACE PACKAGE BODY TEST is
PROCEDURE NetSales(NetSales OUT test.refcur,startDate IN Date, endDate IN Date) IS
BEGIN
OPEN NetSales FOR SELECT * FROM test_mv_sales WHERE orderdate < startDate;
END NetSales;
END;