BEGIN
StartRange_QKN = cast(:StartRange_QK as integer);
WHEN SQLCODE -413
DO ParametersAreNumbers = 0;
END


The when statement checks if the cast failed.

Hope this helps.

Todd



Sandeep Chandra wrote:

> I need to do the following in stor proc
>
> begin
> .
> .
> .
> insert statement..
>
> when sqlcode -803
> do /* nothing */
>
> when any
> do exception some_exception
> end
>
> how do I achieve this
>
> Sandeep
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
> <http://rd.yahoo.com/M=178320.2150041.3600347.1829184/D=egroupweb/S=1705115386:HM/A=979989/R=0/*http://www.fastweb.com/ib/yahoo-79f>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .

[Non-text portions of this message have been removed]