On Tue, 2002-11-12 at 11:26, Sandeep Chandra wrote:

> On Fri, 2002-11-08 at 22:22, Paul Reeves wrote:
> > Sandeep Chandra wrote:
> > > I posted this message yesterday, didn't get any replies, it's quite
> > > urgent, can anyone help please.
> > >
> >
> > You may want to take a look at the Fb1.0 FAQ:
> >
> > http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_fb1_faq
> >
> > The enhancement mentioned made it into the snapshot build 821.
> >
> > FWIW, the problem may appear while gbak says it is restoring indexes,
> > but in fact it is almost certainly caused by the restoration of a stored
> > procedure or trigger.
> >
>
> I have gone thru all my stor procs and triggers,twice, and I still get
> that error. It would have been a bit helpful if the error stor
> proc/trigger was shown.
>
> Anyway, I need to get this thing fixed. What do I do now?

if I have a following in stor proc

declare variable s1 varchar (32000);
declare variable s2 varchar (32000);
declare variable s3 varchar (32000);
.
.
.
and if I want to do the following

s1 = s2 || s3;
I get the same exception. I need to do the above operation how do I get
around it?

Regards

Sandeep