#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Location
    Goi‚nia,GO,Brazil
    Posts
    17
    Rep Power
    0

    Getting to know Firebird better


    Hello guys,

    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??

    Thank you
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    250
    Rep Power
    15
    First of all, in Firebird is there any way I can declare a global variable so I can use it anywhere?
    No, unless you put it in some kind of table (VARIABLES) and query the table in your stored procedures.
    Other question: is there a limit of params I can use in a stored procedure?
    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?
    Martijn Tonies
    Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle
    Upscene Productions
    http://www.upscene.com

IMN logo majestic logo threadwatch logo seochat tools logo