The whole thing is written in one text file and
i am retrieving the script from the text file.

These parameters are passed to the insert statement in the procedures.

eg: parameter2,parameter 3,parameter 4

'00900','10ML
SYRINGE',0,'00593'

second param itemcode,third one is item name and fourth one is categorycode

now two parameters(2 and 3) should be inserted into itemmaster table and
4th one will be inserted in the categorymaster table.

insert into itemmaster('param1,param2)

insert into categorymaster (categorycode,categoryname) values (param4,'hjk')



Sivaraman


At 10:57 AM 14/01/2003 +0100, you wrote:

>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.
> > >
>
>
>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.