On Friday 2002-02-22 at 16:13:44 +1300, Sandeep wrote:

> 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
>

If you're talking about user input, it doesn't really make sense
because there are no users on the server.

If you're talking about input from some system process, then
conceivably you could write a UDF to get the input for you.


David Trudgett