Example

CREATE PROCEDURE SP2 (
PARAM100 VARCHAR(9))
AS
begin
insert into table2 (param_value) values(PARAM100);
End;

CREATE PROCEDURE SP1 (

RETURNS (
PARAM1 VARCHAR(9)
)
AS
begin
Select somethink from table1
Where condition=1
Into PARAM1;

SP2(PARAM1);
End;


-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of majstoru
Sent: Saturday, December 31, 2005 12:17 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Parameters in Strored Procedure

Hi,

> You should use first one SP where u initialise PARAM1 and send after

that to

> your SP as param .

is there any changes if I know which is value of PARAM1, and SP knows
which is PARAM1 I put it into input parameters, just to pass it into
statement?

Thanks ...






++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links