On 24/06/2018 15:13, Dimitry Sibiryakov wrote:
> 24.06.2018 20:09, Adriano dos Santos Fernandes wrote:
>> Here is a valid ISQL code with "TERM ;" and "AUTOTERM ON":
>
> Check it with packages.
>
>
No problem with it, as expected:
------------
SQL> create package pkg
CON> as
CON> begin
CON> procedure p1 (i1 integer) returns (o1 integer);
CON> function f1 returns integer;
CON> end;
SQL>
SQL> create package body pkg
CON> as
CON> begin
CON> procedure p1 (i1 integer) returns (o1 integer)
CON> as
CON> begin
CON> o1 = i1;
CON> suspend;
CON> end
CON>
CON> function f1 returns integer
CON> as
CON> begin
CON> return 2;
CON> end
CON> end;
SQL>
SQL> select p.*, pkg.f1() from pkg.p1(0) p;
O1 F1
============ ============
0 2
------------
Adriano
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
