Is there a way to give a stored proc an input when it is executing
e.g
..
select ..into :a, :b;

if (a <> b)
then begin
[get input value and assign to b];

if (b = 0)
then exit;
end

Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz