ya its in the function
CREATE OR REPLACE FUNCTION Testing(a in varchar2) RETURN number IS
BEGIN
FOR x IN (SELECT DISTINCT id FROM a GROUP BY id) LOOP
blah;
blah;
end loop;
return 1;
end;
I need to replace the "a" in te query from the input parameter...
Thanx
Sam




Reply With Quote