Problem Calling Store Procedure from Powerbuilder in PB/Jaguar architechture

----- Original Message -----
From: Naimesh Trivedi <naimesh@rajmicro.com>
Newsgroups: sybase.public.easerver.powerbuilder
Sent: Wednesday, August 15, 2001 3:13 PM
Subject: Re: Calling Stored Procudure in 3-tier in Powerbuilder/JaguarCTS
architechture


> Hello Mark,
>
> Thanx for ur prompt response. Foll. error is coming
>
> Error ORA-24321 (Zero Iteration count) If done using sqlca syntax shown
> below & Stored Procedure does not
> execute or no row returns (the test sp inserts one row in one table - hard
> coded for testing purpose)
>
> Pls mail me the syntax to write for calling stored procedure  (method of
> jaguar - NVO )
>
> Thanx,
>
> Regards,
>
> Naimesh Trivedi
> Mark Maslow <mark.maslow@sierraclub.org> wrote in message
> news:Kmf5XlOJBHA.299@forums.sybase.com...
> > Can you give us any clues as to what "not working" means?  Any error
> > messages?
> >
> > "Naimesh Trivedi" <naimesh@rajmicro.com> wrote in message
> > news:nK#KZtMJBHA.275@forums.sybase.com...
> > > Hello !
> > >
> > > Well calling Stored procedure conventionally in 2 tier using foll.
diff
> 3
> > > techiniques is not working
> > > in PB 7.x / Jaguar.
> > >
> > > Pls help me in giving the right method.
> > >
> > > A) Sp Calling as per dynamic sql syntax 4
> > >
> > > DECLARE myproc DYNAMIC PROCEDURE FOR sqlsa ;
> > >
> > > PREPARE sqlsa FROM :a_sql ;
> > >
> > > DESCRIBE SQLSA INTO SQLDA ;
> > >
> > >
> > > file://OPEN DYNAMIC myproc USING DESCRIPTOR SQLDA ;
> > >
> > > EXECUTE DYNAMIC myproc USING DESCRIPTOR SQLDA ;
> > >
> > > CLOSE myproc ;
> > >
> > > If Sqlca.sqlcode <> 0 then
> > >  MessageBox("Error", sqlca.sqlErrText)
> > > end if;
> > >
> > > RETURN sqlca.sqlcode;
> > >
> > >
> > >
> > > B) Sp Calling using sqlca
> > >
> > > DECLARE my_proc PROCEDURE FOR T_TEST ;
> > >
> > > EXECUTE my_proc ;
> > > If Sqlca.sqlcode <> 0 then
> > >  MessageBox("Error", sqlca.sqlErrText)
> > > end if;
> > >
> > > RETURN sqlca.sqlcode;
> > >
> > >
> > > C) SP Calling using sqlsa - Dynamic SQL Syntax 3
> > >
> > > SQLSA = CREATE DYNAMICSTAGINGAREA ;
> > >
> > > DECLARE my_proc DYNAMIC PROCEDURE FOR SQLSA ;
> > >
> > > PREPARE SQLSA FROM 'T_TEST()' ;
> > >
> > > EXECUTE DYNAMIC my_proc ;
> > > If Sqlca.sqlcode <> 0 then
> > >  MessageBox("Error", sqlca.sqlErrText)
> > > end if;
> > >
> > > RETURN sqlca.sqlcode;
> > >
> > >
> > >
> > >
> >
> >
>
>


0
Naimesh
8/17/2001 5:16:31 PM
sybase.easerver.powerbuilder 3902 articles. 0 followers. Follow

0 Replies
497 Views

Similar Articles

[PageSpeed] 18

Reply: