Now you've got me puzzled -

You have a whole lot of parameters here - where were
they when you tried SELECT * FROM procname?

--
Martijn

> O.k,
> Instead of select if i write
>
> EXECUTE PROCEDURE DBPROCDOWNLOADFLOPPY('0203/000001','00900','10ML
>

SYRINGE',0,'00593','N','N',0,'Y','N','',0,'','N',100,1,0,0,'Y','N','','','',
'00000','SOFTWA','PHARMA1','7049',13,0,7,7,0,'2004/06',3.8,'N',10,'200406',7
,'GENERAL','SOFTWA','PAHRMA3','GENERAL','SOFTWA','ELD_HOSP','','','','','','
',0,'','','','','','','','','','','','','','','','','','','','','',10)

>
> Now it is giving error as
>
> isc error message
>
> message length error (encountered 0,expercted 3).
>
>
> Sivaraman
>
>
> At 08:29 PM 14/01/2003 +1100, you wrote:
> >At 02:55 PM 14/01/2003 +0530, you wrote:
> > >Helen,
> > >
> > > I need to solve this problem right now.Can u help me?
> > >
> > > When i execute one one procedure thro' query in ib_sql it is

executing

> > >without saying any error.
> > >But inside the procedure, i had written one insert query.But that row

is

> > >not inserted.
> > >
> > >select * from dbprocdownloadfloppy('si','ij');
> >
> >That looks like nonsense for a DML query. You don't perform a SELECT

query

> >to perform an insert.
> >