December 4th, 2003, 11:17 AM
Getting to know Firebird better
I'm new to Firebird and I'd like to make some questions about it.
First of all, in Firebird is there any way I can declare a global variable so I can use it anywhere? WHat I mean is: I wanna declare a variable, use it and change it in any stored procedure. I do something like this in Oracle, using Packages.
Other question: is there a limit of params I can use in a stored procedure??
December 12th, 2003, 07:39 AM
No, unless you put it in some kind of table (VARIABLES) and query the table in your stored procedures.
I guess there is, but if you reach this limit, I suspect you have other problems ... Care to tell how many you are trying or what number of parameters you have in mind?
Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle