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.
>
>HB
>
>
>
> >This is that sql.
> >In the front end(Delphi 5.0 ib_script,), i am getting this sql from one
> >text file and
> >when i execute script, nothing happened.
> >
> >What could be the problem?where i am doing mistake??
> >
> >Sivaraman
> >Software Associates Information Technology
> >Calicut,
> >india
> >
> >
> >
> >To unsubscribe from this group, send an email to:
> >ib-support-unsubscribe@egroups.com
> >
> >
> >
> >Your use of Yahoo! Groups is subject to
> <http://docs.yahoo.com/info/terms/>http://docs.yahoo.com/info/terms/
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to the
><http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.