You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Compare results of SHOW PROC vs SHOW FUNC in ISQL:
SQL> set term ^; create or alter procedure p01(x int) returns (z int) as begin z=x*2; suspend; end^
SQL> set term ;^
SQL> commit;
SQL> show proc p01;
Procedure text:
begin z=x*2; suspend; end
Parameters:
X INPUT INTEGER
Z OUTPUT INTEGER
=== vs ===
SQL> set term ^; create or alter function f01(x int) returns int as begin return x*2; end^
SQL> set term ;^
SQL> commit;
SQL> show function f01;
Function F01:
Function library is
Entry point is
Returns BY VALUE
Argument 1: BY VALUE
Is it possible to display results for `SHOW FUNC` command in such manner as for `SHOW PROC` ? (i.e. show body and in-out arguments just like in SHOW PROC)
The text was updated successfully, but these errors were encountered:
As this should also work for UDF with an external library, where information like Entry point etc is important, I think the current information should still be displayed if it is a UDF with an external library.
Submitted by: @pavel-zotov
Compare results of SHOW PROC vs SHOW FUNC in ISQL:
SQL> set term ^; create or alter procedure p01(x int) returns (z int) as begin z=x*2; suspend; end^
SQL> set term ;^
SQL> commit;
SQL> show proc p01;
Procedure text:
begin z=x*2; suspend; end
Parameters:
X INPUT INTEGER
Z OUTPUT INTEGER
=== vs ===
SQL> set term ^; create or alter function f01(x int) returns int as begin return x*2; end^
SQL> set term ;^
SQL> commit;
SQL> show function f01;
Function F01:
Function library is
Entry point is
Returns BY VALUE
Argument 1: BY VALUE
Is it possible to display results for `SHOW FUNC` command in such manner as for `SHOW PROC` ? (i.e. show body and in-out arguments just like in SHOW PROC)
The text was updated successfully, but these errors were encountered: