> In firebird is there an option to declare a parameter in a stored procedure > as an IN/OUT. (like ORACLE server has) > http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/parameter_declaration. > htm > > > > > > I want to send a parameter to a procedure, do some operation with it, and > return his new value.
No, not with a single parameter. PSQL requires an explicit list of return parameters, of course with different parameter names as the input parameters. The language reference is available here: http://www.firebirdsql.org/refdocs/langrefupd25-ddl-procedure.html -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
