Re: Oracle Stored Proc issues

On 06.09.2006 21:45, DA Morgan wrote:
> KK wrote:

>> That sounds good. I  use the value in the update statement.
>>
>> something like
>> update ... where xyz in ( variable )

Btw, just curious why are you using "in" instead of "="?

> Then declare the variable dynamically as in:
>
> DECLARE
> myvariable mytable.mycolumn%TYPE;
> BEGIN
... and make sure on assignment that the value is not larger or catch the error or let it propagate. Making it longer than the table column does not make sense in this context.

Kind regards

        robert Received on Thu Sep 07 2006 - 02:22:40 CDT