You have to use the procedure in a TQuery in the SQL expression:

SELECT * FROM SP(:STRING_PARAM)

.ExecProc is only useful fro stored procedure without a result set.

Best success
Christian

--- In firebird-support@yahoogroups.com, "Farshid Dehghan" <f_ksh3600@...> wrote:
>
> Yes, but can not find anything
>
> --- In firebird-support@yahoogroups.com, Nick Upson <nu@> wrote:
> >
> > are you doing "execute procedure SP" or "select * from SP"? , you want the
> > "select ..." form
> >
> > Nick Upson
> >
> >
> >
> > On 24 August 2012 15:15, Farshid Dehghan <f_ksh3600@> wrote:
> >
> > > **
> > >
> > >
> > > Thanks for the answer
> > > But I had forgotten the "For" the Mail wrote.
> > > Add This word does not solve the problem
> > >
> > > --- In firebird-support@yahoogroups.com, "Ismael L. Donis Garcia" <ismael@>
> > > wrote:
> > > >
> > > > add FOR to SELECT
> > > >
> > > >
> > > > SET TERM ^ ;
> > > > CREATE PROCEDURE SP(
> > > > TLek VARCHAR(15) CHARACTER SET NONE COLLATE NONE)
> > > > RETURNS(
> > > > PNAME VARCHAR(100) CHARACTER SET NONE COLLATE NONE)
> > > > AS
> > > > BEGIN
> > > > for Select Name FROM TBL1 Where (TLekName = :TLek) ORDER BY ID
> > > > Into :PName DO
> > > > SUSPEND;
> > > > END ^
> > > > SET TERM ^ ;
> > > >
> > > >
> > > > =========
> > > > || ISMAEL ||
> > > > =========
> > > > ----- Original Message -----
> > > > From: Farshid Dehghan
> > > > To: firebird-support@yahoogroups.com
> > > > Sent: Thursday, August 23, 2012 1:16 PM
> > > > Subject: [firebird-support] Problem IBStoredProc
> > > >
> > > >
> > > >
> > > > Hi
> > > > I've used Delphi IBStoredProc, But not run.
> > > > No error.
> > > > Please get help
> > > >
> > > > //----------in firebird
> > > > SET TERM ^ ;
> > > > CREATE PROCEDURE SP(
> > > > TLek VARCHAR(15) CHARACTER SET NONE COLLATE NONE)
> > > > RETURNS(
> > > > PNAME VARCHAR(100) CHARACTER SET NONE COLLATE NONE)
> > > > AS
> > > > BEGIN
> > > > Select Name FROM TBL1 Where (TLekName = :TLek) ORDER BY ID
> > > > Into :PName DO
> > > > SUSPEND;
> > > > END ^
> > > > SET TERM ^ ;
> > > >
> > > > //----------in delphi
> > > > IBStoredProc1.StoredProcName := 'SP';
> > > > IBStoredProc1.ParamByName('TLek').AsString := 'mb';
> > > > IBStoredProc1.ExecProc;
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>