Re: [firebird-support] IN OUT PARAMETERS
12.05.2016 9:49, 'Mihalache Bogdan' bogdan.mihala...@soter.ro [firebird-support] wrote: > In firebird is there an option to declare a parameter in a stored procedure > as an IN/OUT. No. Read Language Reference. IN parameters are completely separated from OUT parameters. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] IN OUT PARAMETERS
> 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.
[firebird-support] IN OUT PARAMETERS
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. Thank you!