you could stuff these "variables" and "constants" into another table, and
get stored procedures to get the values from them.

-----Original Message-----
From: Robert Razniewski [mailto:gustaf@...]
Sent: 24 July 2003 10:30
To: firebird-support@yahoogroups.com
Subject: [firebird-support] constants and variables


Hi all.


Is there a possibility to define a constant or variable, that can be
accessed from all stored procedures?
I have to write a procedure which is called very often and needs to read
some parameters.

I would like the following scenario:
1. a prepare procedure reads the params into variable
2. the main procedure uses the variables

Is this possible?


regards
rr





To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/