Tell us the component you are using and wire up a SQL trace monitor and show
the results of the exception to us.

Jason

> -----Original Message-----
> From: Malcolm Smith [mailto:m.smith@...]
> Sent: Friday, November 26, 2004 12:11 AM
> To: IBObjects@yahoogroups.com
> Subject: RE: [IBO] A problem with a procedure
>
>
>
> As per email before (other than that nowhere that I know of):
>
> >BEGIN
> > SELECT
> > LP_PROCESSNAME,
> > LP_LOGMASK,
> > LP_LOGPATH,
> > LP_DAYLIMIT
> > FROM
> > LOGPARAMS
> > WHERE
> > UPPER(LP_PROCESSNAME) = UPPER(:LP_PROCESSNAME_IN)
> > INTO
> > :LP_PROCESSNAME,
> > :LP_LOGMASK,
> > :LP_LOGPATH,
> > :LP_DAYLIMIT;
> > SUSPEND;
> >END
>
> I get no exception if I use "SELECT *" so I can't imagine
> there is anything
> in my code.
>
>
> Malcolm Smith
> Analyst Programmer
> Comvision Pty Ltd
> http://www.comvision.net.au
>
>