Re: [firebird-support] IN OUT PARAMETERS

2016-05-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
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

2016-05-12 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
> 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

2016-05-12 Thread 'Mihalache Bogdan' bogdan.mihala...@soter.ro [firebird-support]
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!