1659 lines
63 KiB
Plaintext
1659 lines
63 KiB
Plaintext
create extension gms_output;
|
|
create schema gms_output_test;
|
|
set search_path=gms_output_test;
|
|
-- test gms_output.disable
|
|
select gms_output.DISABLE;
|
|
disable
|
|
---------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.DISABLE(null);
|
|
ERROR: function gms_output.disable(unknown) does not exist
|
|
LINE 1: select gms_output.DISABLE(null);
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: disable
|
|
select gms_output.DISABLE();
|
|
disable
|
|
---------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.DISABLE('');
|
|
ERROR: function gms_output.disable(unknown) does not exist
|
|
LINE 1: select gms_output.DISABLE('');
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: disable
|
|
select gms_output.DISABLE(0);
|
|
ERROR: function gms_output.disable(integer) does not exist
|
|
LINE 1: select gms_output.DISABLE(0);
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: disable
|
|
select gms_output.DISABLE("""");
|
|
ERROR: column """ does not exist
|
|
LINE 1: select gms_output.DISABLE("""");
|
|
^
|
|
CONTEXT: referenced column: disable
|
|
select gms_output.DISABLE(@);
|
|
ERROR: syntax error at or near ")"
|
|
LINE 1: select gms_output.DISABLE(@);
|
|
^
|
|
select gms_output.DISABLE(あ);
|
|
ERROR: column "あ" does not exist
|
|
LINE 1: select gms_output.DISABLE(あ);
|
|
^
|
|
CONTEXT: referenced column: disable
|
|
select gms_output.DISABLE(%);
|
|
ERROR: syntax error at or near "%"
|
|
LINE 1: select gms_output.DISABLE(%);
|
|
^
|
|
select gms_output.DISABLE('qqqq');
|
|
ERROR: function gms_output.disable(unknown) does not exist
|
|
LINE 1: select gms_output.DISABLE('qqqq');
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: disable
|
|
select gms_output.DISABLE;
|
|
disable
|
|
---------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.PUT_LINE('adsfds');
|
|
put_line
|
|
----------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.GET_LINE(0,1);
|
|
get_line
|
|
----------
|
|
(,1)
|
|
(1 row)
|
|
|
|
-- test gms_output.enable
|
|
select gms_output.enable(1000000);
|
|
enable
|
|
--------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.enable(20000);
|
|
enable
|
|
--------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.enable(1000001);
|
|
WARNING: Limit decreased to 1000000 bytes.
|
|
CONTEXT: referenced column: enable
|
|
enable
|
|
--------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.enable(19999);
|
|
enable
|
|
--------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.enable(30000);
|
|
enable
|
|
--------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.enable(power(2,31));
|
|
ERROR: integer out of range
|
|
CONTEXT: referenced column: enable
|
|
select gms_output.enable(-555.55);
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: referenced column: enable
|
|
enable
|
|
--------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.enable(0.555.55);
|
|
ERROR: syntax error at or near "0.555.55"
|
|
LINE 1: select gms_output.enable(0.555.55);
|
|
^
|
|
select gms_output.enable(000.555);
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: referenced column: enable
|
|
enable
|
|
--------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.enable(ssss);
|
|
ERROR: column "ssss" does not exist
|
|
LINE 1: select gms_output.enable(ssss);
|
|
^
|
|
CONTEXT: referenced column: enable
|
|
select gms_output.enable('ssss');
|
|
ERROR: invalid input syntax for integer: "ssss"
|
|
LINE 1: select gms_output.enable('ssss');
|
|
^
|
|
CONTEXT: referenced column: enable
|
|
select gms_output.enable(-power(2,32));
|
|
ERROR: integer out of range
|
|
CONTEXT: referenced column: enable
|
|
select gms_output.enable(-power(2,21));
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: referenced column: enable
|
|
enable
|
|
--------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.enable(a);
|
|
ERROR: column "a" does not exist
|
|
LINE 1: select gms_output.enable(a);
|
|
^
|
|
CONTEXT: referenced column: enable
|
|
select gms_output.enable('a');
|
|
ERROR: invalid input syntax for integer: "a"
|
|
LINE 1: select gms_output.enable('a');
|
|
^
|
|
CONTEXT: referenced column: enable
|
|
select gms_output.enable(' ');
|
|
ERROR: invalid input syntax for integer: " "
|
|
LINE 1: select gms_output.enable(' ');
|
|
^
|
|
CONTEXT: referenced column: enable
|
|
select gms_output.enable(null);
|
|
enable
|
|
--------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.enable(0);
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: referenced column: enable
|
|
enable
|
|
--------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.enable(あ);
|
|
ERROR: column "あ" does not exist
|
|
LINE 1: select gms_output.enable(あ);
|
|
^
|
|
CONTEXT: referenced column: enable
|
|
select gms_output.enable('あ');
|
|
ERROR: invalid input syntax for integer: "あ"
|
|
LINE 1: select gms_output.enable('あ');
|
|
^
|
|
CONTEXT: referenced column: enable
|
|
select gms_output.enable('@');
|
|
ERROR: invalid input syntax for integer: "@"
|
|
LINE 1: select gms_output.enable('@');
|
|
^
|
|
CONTEXT: referenced column: enable
|
|
select gms_output.enable(1000,1000);
|
|
ERROR: function gms_output.enable(integer, integer) does not exist
|
|
LINE 1: select gms_output.enable(1000,1000);
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: enable
|
|
select gms_output.enable(1000,null);
|
|
ERROR: function gms_output.enable(integer, unknown) does not exist
|
|
LINE 1: select gms_output.enable(1000,null);
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: enable
|
|
select gms_output.enable('null');
|
|
ERROR: invalid input syntax for integer: "null"
|
|
LINE 1: select gms_output.enable('null');
|
|
^
|
|
CONTEXT: referenced column: enable
|
|
select gms_output.enable('山东东海偶然打赏');
|
|
ERROR: invalid input syntax for integer: "山东东海偶然打赏"
|
|
LINE 1: select gms_output.enable('山东东海偶然打赏');
|
|
^
|
|
CONTEXT: referenced column: enable
|
|
select gms_output.enable(0);
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: referenced column: enable
|
|
enable
|
|
--------
|
|
|
|
(1 row)
|
|
|
|
create table t(a int, b int, c int);
|
|
insert into t values(111111,222222,333333);
|
|
insert into t values(444444,555555,666666);
|
|
insert into t values(777777,888888,999999);
|
|
create table tt(aa int,bb varchar2(100));
|
|
declare
|
|
msg varchar2(120);
|
|
cursor t_cur is select * from t order by a;
|
|
v_line varchar2(100);
|
|
v_status integer := 0;
|
|
begin
|
|
gms_output.enable;
|
|
for i in t_cur loop
|
|
msg := i.a || ',' || i.b || ',' || i.c;
|
|
gms_output.put_line(msg);
|
|
end loop;
|
|
|
|
gms_output.get_line(v_line, v_status);
|
|
while v_status = 0 loop
|
|
insert into tt values(v_status, v_line);
|
|
gms_output.get_line(v_line, v_status);
|
|
end loop;
|
|
end;
|
|
/
|
|
111111,222222,333333
|
|
444444,555555,666666
|
|
777777,888888,999999
|
|
--查看结果
|
|
select * from tt;
|
|
aa | bb
|
|
----+----------------------
|
|
0 | 111111,222222,333333
|
|
0 | 444444,555555,666666
|
|
0 | 777777,888888,999999
|
|
(3 rows)
|
|
|
|
--清理资源
|
|
drop table t;
|
|
drop table tt;
|
|
-- test gms_output.get_line
|
|
begin
|
|
gms_output.ENABLE(100);
|
|
gms_output.put('This ');
|
|
end;
|
|
/
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: SQL statement "CALL gms_output.enable(100)"
|
|
PL/pgSQL function inline_code_block line 2 at PERFORM
|
|
This
|
|
select gms_output.GET_LINE();
|
|
ERROR: function gms_output.get_line() does not exist
|
|
LINE 1: select gms_output.GET_LINE();
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
begin
|
|
gms_output.ENABLE(100);
|
|
gms_output.put();
|
|
end;
|
|
/
|
|
ERROR: function gms_output.put has no enough parameters
|
|
CONTEXT: compilation of PL/pgSQL function "inline_code_block" near line 2
|
|
select gms_output.GET_LINE();
|
|
ERROR: function gms_output.get_line() does not exist
|
|
LINE 1: select gms_output.GET_LINE();
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
begin
|
|
gms_output.ENABLE(100);
|
|
gms_output.put(null);
|
|
end;
|
|
/
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: SQL statement "CALL gms_output.enable(100)"
|
|
PL/pgSQL function inline_code_block line 2 at PERFORM
|
|
select gms_output.GET_LINE();
|
|
ERROR: function gms_output.get_line() does not exist
|
|
LINE 1: select gms_output.GET_LINE();
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
begin
|
|
gms_output.ENABLE(100);
|
|
gms_output.put(null);
|
|
end;
|
|
/
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: SQL statement "CALL gms_output.enable(100)"
|
|
PL/pgSQL function inline_code_block line 2 at PERFORM
|
|
select gms_output.GET_LINE();
|
|
ERROR: function gms_output.get_line() does not exist
|
|
LINE 1: select gms_output.GET_LINE();
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
begin
|
|
gms_output.ENABLE(100);
|
|
gms_output.put(-999888,pppp);
|
|
end;
|
|
/
|
|
ERROR: when invoking function gms_output.put, expected ")", maybe input something superfluous.
|
|
CONTEXT: compilation of PL/pgSQL function "inline_code_block" near line 2
|
|
select gms_output.GET_LINE();
|
|
ERROR: function gms_output.get_line() does not exist
|
|
LINE 1: select gms_output.GET_LINE();
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
begin
|
|
gms_output.ENABLE(100);
|
|
gms_output.put(123213123);
|
|
end;
|
|
/
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: SQL statement "CALL gms_output.enable(100)"
|
|
PL/pgSQL function inline_code_block line 2 at PERFORM
|
|
123213123
|
|
select gms_output.GET_LINE();
|
|
ERROR: function gms_output.get_line() does not exist
|
|
LINE 1: select gms_output.GET_LINE();
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
begin
|
|
gms_output.ENABLE(100);
|
|
gms_output.put('未来更快更高更强,hsdufdsnjfs,shfusdfjfjs,12313213');
|
|
end;
|
|
/
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: SQL statement "CALL gms_output.enable(100)"
|
|
PL/pgSQL function inline_code_block line 2 at PERFORM
|
|
未来更快更高更强,hsdufdsnjfs,shfusdfjfjs,12313213
|
|
select gms_output.GET_LINE();
|
|
ERROR: function gms_output.get_line() does not exist
|
|
LINE 1: select gms_output.GET_LINE();
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
begin
|
|
gms_output.ENABLE(100);
|
|
gms_output.put('未来更快更高更强');
|
|
end;
|
|
/
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: SQL statement "CALL gms_output.enable(100)"
|
|
PL/pgSQL function inline_code_block line 2 at PERFORM
|
|
未来更快更高更强
|
|
select gms_output.GET_LINE();
|
|
ERROR: function gms_output.get_line() does not exist
|
|
LINE 1: select gms_output.GET_LINE();
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
begin
|
|
gms_output.ENABLE(100);
|
|
gms_output.put('@#￥#@@#！@#！#￥@%%');
|
|
end;
|
|
/
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: SQL statement "CALL gms_output.enable(100)"
|
|
PL/pgSQL function inline_code_block line 2 at PERFORM
|
|
@#￥#@@#！@#！#￥@%%
|
|
select gms_output.GET_LINE();
|
|
ERROR: function gms_output.get_line() does not exist
|
|
LINE 1: select gms_output.GET_LINE();
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
begin
|
|
gms_output.ENABLE(100);
|
|
gms_output.put('2017-09-23');
|
|
end;
|
|
/
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: SQL statement "CALL gms_output.enable(100)"
|
|
PL/pgSQL function inline_code_block line 2 at PERFORM
|
|
2017-09-23
|
|
select gms_output.GET_LINE();
|
|
ERROR: function gms_output.get_line() does not exist
|
|
LINE 1: select gms_output.GET_LINE();
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
|
|
begin
|
|
gms_output.ENABLE(100);
|
|
gms_output.put('2017-09-23 12:23:29,2000/07/99');
|
|
end;
|
|
/
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: SQL statement "CALL gms_output.enable(100)"
|
|
PL/pgSQL function inline_code_block line 2 at PERFORM
|
|
2017-09-23 12:23:29,2000/07/99
|
|
select gms_output.GET_LINE();
|
|
ERROR: function gms_output.get_line() does not exist
|
|
LINE 1: select gms_output.GET_LINE();
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
begin
|
|
gms_output.ENABLE(100);
|
|
gms_output.put('Time Started: ' || TO_CHAR('2001-09-28 01:00:00'::timestamp, 'DD-MON-YYYY HH24:MI:SS'));
|
|
end;
|
|
/
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: SQL statement "CALL gms_output.enable(100)"
|
|
PL/pgSQL function inline_code_block line 2 at PERFORM
|
|
Time Started: 28-SEP-2001 01:00:00
|
|
select gms_output.GET_LINE();
|
|
ERROR: function gms_output.get_line() does not exist
|
|
LINE 1: select gms_output.GET_LINE();
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
begin
|
|
gms_output.ENABLE(100);
|
|
gms_output.put('Time Started: ' || TO_CHAR('2001-09-28 01:00:00'::timestamp, 'DD-MON-YYYY HH24:MI:SS'));
|
|
end;
|
|
/
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: SQL statement "CALL gms_output.enable(100)"
|
|
PL/pgSQL function inline_code_block line 2 at PERFORM
|
|
Time Started: 28-SEP-2001 01:00:00
|
|
begin
|
|
gms_output.ENABLE(100);
|
|
gms_output.put('∵∴∷♂♀°℃＄¤￠￡‰§№☆*〇○*◎** 回□*△▽⊿▲▼▁▂▃▄▆**▉▊▋▌▍▎▏※→←↑↓↖↗↘↙** ⅰⅱⅲⅳⅴⅵⅶⅷⅸⅹ①②③④⑤⑥⑦⑧⑨⑩⒈⒉⒊⒋ ⒌⒍⒎⒏⒐⒑⒒⒓⒔⒕⒖⒗⒘⒙⒚⒛⑴⑵⑶⑷⑸⑹⑺⑻⑼⑽⑾⑿⒀⒁⒂⒃⒄⒅⒆⒇㈠㈡㈢㈣㈤㈥㈦㈧㈨㈩ⅠⅡⅢⅣⅤⅥⅦⅧⅨⅩⅪⅫぁあぃいぅうぇえぉおかがきぎくぐけげこごさざしじすずせぜそぞただちぢっつづてでとどなにぬねのはばぱひびぴふぶぷへべぺほぼぽまみむめもゃやゅゆょよらりるれろゎわゐゑをんァアィイゥウェエォオカガキギクグケゲコゴサザシジスズセゼソゾタダチヂッツヅテデトドナニヌネノハバパヒビピフブプヘベペホボポマミムメモャヤュユョヨラリルレロヮワヰヱヲンヴヵヶΑΒΓΔΕΖΗΘΙΚΛΜΝΞΟΠΡΣΤΥΦΧΨΩαβγδεζηθ ικλμνξοπρστυφχψ ω︵︶︹︺︿﹀︽︾﹁﹂﹃﹄︻');
|
|
end;
|
|
/
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: SQL statement "CALL gms_output.enable(100)"
|
|
PL/pgSQL function inline_code_block line 2 at PERFORM
|
|
∵∴∷♂♀°℃＄¤￠￡‰§№☆*〇○*◎** 回□*△▽⊿▲▼▁▂▃▄▆**▉▊▋▌▍▎▏※→←↑↓↖↗↘↙** ⅰⅱⅲⅳⅴⅵⅶⅷⅸⅹ①②③④⑤⑥⑦⑧⑨⑩⒈⒉⒊⒋ ⒌⒍⒎⒏⒐⒑⒒⒓⒔⒕⒖⒗⒘⒙⒚⒛⑴⑵⑶⑷⑸⑹⑺⑻⑼⑽⑾⑿⒀⒁⒂⒃⒄⒅⒆⒇㈠㈡㈢㈣㈤㈥㈦㈧㈨㈩ⅠⅡⅢⅣⅤⅥⅦⅧⅨⅩⅪⅫぁあぃいぅうぇえぉおかがきぎくぐけげこごさざしじすずせぜそぞただちぢっつづてでとどなにぬねのはばぱひびぴふぶぷへべぺほぼぽまみむめもゃやゅゆょよらりるれろゎわゐゑをんァアィイゥウェエォオカガキギクグケゲコゴサザシジスズセゼソゾタダチヂッツヅテデトドナニヌネノハバパヒビピフブプヘベペホボポマミムメモャヤュユョヨラリルレロヮワヰヱヲンヴヵヶΑΒΓΔΕΖΗΘΙΚΛΜΝΞΟΠΡΣΤΥΦΧΨΩαβγδεζηθ ικλμνξοπρστυφχψ ω︵︶︹︺︿﹀︽︾﹁﹂﹃﹄︻
|
|
select gms_output.GET_LINE();
|
|
ERROR: function gms_output.get_line() does not exist
|
|
LINE 1: select gms_output.GET_LINE();
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
begin
|
|
gms_output.ENABLE(100);
|
|
gms_output.put('This ');
|
|
gms_output.put('is ');
|
|
gms_output.new_line();
|
|
end;
|
|
/
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: SQL statement "CALL gms_output.enable(100)"
|
|
PL/pgSQL function inline_code_block line 2 at PERFORM
|
|
This
|
|
is
|
|
select gms_output.GET_LINE();
|
|
ERROR: function gms_output.get_line() does not exist
|
|
LINE 1: select gms_output.GET_LINE();
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
begin
|
|
gms_output.ENABLE(100);
|
|
gms_output.put('This ');
|
|
gms_output.put('is ');
|
|
gms_output.put('函数测试历史的反思的');
|
|
end;
|
|
/
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: SQL statement "CALL gms_output.enable(100)"
|
|
PL/pgSQL function inline_code_block line 2 at PERFORM
|
|
This
|
|
is
|
|
函数测试历史的反思的
|
|
select gms_output.GET_LINE();
|
|
ERROR: function gms_output.get_line() does not exist
|
|
LINE 1: select gms_output.GET_LINE();
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
select gms_output.GET_LINE(power(2,32));
|
|
ERROR: function gms_output.get_line(double precision) does not exist
|
|
LINE 1: select gms_output.GET_LINE(power(2,32));
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
select gms_output.GET_LINE(power(2,9999));
|
|
ERROR: function gms_output.get_line(double precision) does not exist
|
|
LINE 1: select gms_output.GET_LINE(power(2,9999));
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
select gms_output.GET_LINE(あ@ 、iohgfvcs大富大贵);
|
|
ERROR: column "あ" does not exist
|
|
LINE 1: select gms_output.GET_LINE(あ@ 、iohgfvcs大富大贵);
|
|
^
|
|
CONTEXT: referenced column: get_line
|
|
select gms_output.GET_LINE();
|
|
ERROR: function gms_output.get_line() does not exist
|
|
LINE 1: select gms_output.GET_LINE();
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
select gms_output.GET_LINE('');
|
|
ERROR: function gms_output.get_line(unknown) does not exist
|
|
LINE 1: select gms_output.GET_LINE('');
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
select gms_output.GET_LINE(null);
|
|
ERROR: function gms_output.get_line(unknown) does not exist
|
|
LINE 1: select gms_output.GET_LINE(null);
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
select gms_output.GET_LINE('aaaa');
|
|
ERROR: function gms_output.get_line(unknown) does not exist
|
|
LINE 1: select gms_output.GET_LINE('aaaa');
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
select gms_output.GET_LINE('和士大夫大师傅即使对方');
|
|
ERROR: function gms_output.get_line(unknown) does not exist
|
|
LINE 1: select gms_output.GET_LINE('和士大夫大师傅即使对方');
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
select gms_output.GET_LINE(111);
|
|
ERROR: function gms_output.get_line(integer) does not exist
|
|
LINE 1: select gms_output.GET_LINE(111);
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
select gms_output.GET_LINE(0);
|
|
ERROR: function gms_output.get_line(integer) does not exist
|
|
LINE 1: select gms_output.GET_LINE(0);
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
SET search_path to gms_output;
|
|
create table t(a int, b int, c int);
|
|
create table tt(aa int,bb varchar2(100));
|
|
insert into t values(111111,222222,333333);
|
|
insert into t values(444444,555555,666666);
|
|
insert into t values(777777,888888,999999);
|
|
declare
|
|
msg varchar2(120);
|
|
cursor t_cur is select * from t order by a;
|
|
v_line varchar2(100);
|
|
v_status integer := 0;
|
|
begin
|
|
gms_output.disable();
|
|
gms_output.enable;
|
|
for i in t_cur loop
|
|
msg := i.a || ',' || i.b || ',' || i.c;
|
|
raise notice 'msg=%',msg;
|
|
gms_output.put_line(msg);
|
|
end loop;
|
|
|
|
gms_output.get_line(v_line, v_status);
|
|
while v_status = 0 loop
|
|
raise notice 'v_line=%,v_status=%',v_line,v_status;
|
|
insert into tt values(v_status, v_line);
|
|
gms_output.get_line(v_line, v_status);
|
|
end loop;
|
|
end;
|
|
/
|
|
NOTICE: msg=111111,222222,333333
|
|
111111,222222,333333
|
|
NOTICE: msg=444444,555555,666666
|
|
444444,555555,666666
|
|
NOTICE: msg=777777,888888,999999
|
|
777777,888888,999999
|
|
NOTICE: v_line=111111,222222,333333,v_status=0
|
|
NOTICE: v_line=444444,555555,666666,v_status=0
|
|
NOTICE: v_line=777777,888888,999999,v_status=0
|
|
select * from tt;
|
|
aa | bb
|
|
----+----------------------
|
|
0 | 111111,222222,333333
|
|
0 | 444444,555555,666666
|
|
0 | 777777,888888,999999
|
|
(3 rows)
|
|
|
|
delete from t;
|
|
delete from tt;
|
|
declare
|
|
v_line varchar2(100);
|
|
v_status integer := 0;
|
|
begin
|
|
gms_output.enable;
|
|
gms_output.put('This ');
|
|
gms_output.new_line;
|
|
gms_output.put('end ');
|
|
|
|
gms_output.get_line(v_line, v_status);
|
|
while v_status = 0 loop
|
|
raise notice 'v_line=%,v_status=%',v_line,v_status;
|
|
insert into tt values(v_status, v_line);
|
|
gms_output.get_line(v_line, v_status);
|
|
end loop;
|
|
end;
|
|
/
|
|
This
|
|
end
|
|
NOTICE: v_line=This ,v_status=0
|
|
NOTICE: v_line=end ,v_status=0
|
|
select * from tt;
|
|
aa | bb
|
|
----+-------
|
|
0 | This
|
|
0 | end
|
|
(2 rows)
|
|
|
|
-- test gms_output.get_lines
|
|
begin
|
|
gms_output.enable(100);
|
|
gms_output.PUT_LINE('{131231321312313},{dhsfsdjfsdf}');
|
|
gms_output.PUT_LINE('{好还是打发士大夫},{dhsfsdjfsdf}');
|
|
end;
|
|
/
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: SQL statement "CALL gms_output.enable(100)"
|
|
PL/pgSQL function inline_code_block line 2 at PERFORM
|
|
{131231321312313},{dhsfsdjfsdf}
|
|
{好还是打发士大夫},{dhsfsdjfsdf}
|
|
select gms_output.get_lines('{lines}',3);
|
|
get_lines
|
|
----------------------------------------------------------------------------------
|
|
("{""{131231321312313},{dhsfsdjfsdf}"",""{好还是打发士大夫},{dhsfsdjfsdf}""}",2)
|
|
(1 row)
|
|
|
|
begin
|
|
gms_output.enable(100);
|
|
gms_output.PUT_LINE('{131231321312313,wrewerwr,werwerw},{dhsfsdjfsdf}');
|
|
gms_output.PUT_LINE('88无任何为维护差旅费{dhsfsdjfsdf}');
|
|
gms_output.PUT_LINE('u威力五二年初的v下');
|
|
end;
|
|
/
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: SQL statement "CALL gms_output.enable(100)"
|
|
PL/pgSQL function inline_code_block line 2 at PERFORM
|
|
{131231321312313,wrewerwr,werwerw},{dhsfsdjfsdf}
|
|
88无任何为维护差旅费{dhsfsdjfsdf}
|
|
u威力五二年初的v下
|
|
select gms_output.get_lines('{lines}',3);
|
|
get_lines
|
|
-----------------------------------------------------------------------------------------------------------------------
|
|
("{""{131231321312313,wrewerwr,werwerw},{dhsfsdjfsdf}"",""88无任何为维护差旅费{dhsfsdjfsdf}"",u威力五二年初的v下}",3)
|
|
(1 row)
|
|
|
|
begin
|
|
gms_output.enable(100);
|
|
gms_output.PUT_LINE('[131231321312313,wrewerwr,werwerw},{dhsfsdjfsdf]');
|
|
gms_output.PUT_LINE('∵∴∷♂♀°℃＄¤￠￡‰§№☆*〇○*◎** 回□*△▽⊿▲▼▁▂▃▄▆**▉▊▋▌▍▎▏※→←↑↓↖↗↘↙** ⅰⅱⅲⅳⅴⅵⅶⅷⅸⅹ①②③④⑤⑥⑦⑧⑨⑩⒈⒉⒊⒋ ⒌⒍⒎⒏⒐⒑⒒⒓⒔⒕⒖⒗⒘⒙⒚⒛⑴⑵⑶⑷⑸⑹⑺⑻⑼⑽⑾⑿⒀⒁⒂⒃⒄⒅⒆⒇㈠㈡㈢㈣㈤㈥㈦㈧㈨㈩ⅠⅡⅢⅣⅤⅥⅦⅧⅨⅩⅪⅫぁあぃいぅうぇえぉおかがきぎくぐけげこごさざしじすずせぜそぞただちぢっつづてでとどなにぬねのはばぱひびぴふぶぷへべぺほぼぽまみむめもゃやゅゆょよらりるれろゎわゐゑをんァアィイゥウェエォオカガキギクグケゲコゴサザシジスズセゼソゾタダチヂッツヅテデトドナニヌネノハバパヒビピフブプヘベペホボポマミムメモャヤュユョヨラリルレロヮワヰヱヲンヴヵヶΑΒΓΔΕΖΗΘΙΚΛΜΝΞΟΠΡΣΤΥΦΧΨΩαβγδεζηθ ικλμνξοπρστυφχψ ω︵︶︹︺︿﹀︽︾﹁﹂﹃﹄︻');
|
|
end;
|
|
/
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: SQL statement "CALL gms_output.enable(100)"
|
|
PL/pgSQL function inline_code_block line 2 at PERFORM
|
|
[131231321312313,wrewerwr,werwerw},{dhsfsdjfsdf]
|
|
∵∴∷♂♀°℃＄¤￠￡‰§№☆*〇○*◎** 回□*△▽⊿▲▼▁▂▃▄▆**▉▊▋▌▍▎▏※→←↑↓↖↗↘↙** ⅰⅱⅲⅳⅴⅵⅶⅷⅸⅹ①②③④⑤⑥⑦⑧⑨⑩⒈⒉⒊⒋ ⒌⒍⒎⒏⒐⒑⒒⒓⒔⒕⒖⒗⒘⒙⒚⒛⑴⑵⑶⑷⑸⑹⑺⑻⑼⑽⑾⑿⒀⒁⒂⒃⒄⒅⒆⒇㈠㈡㈢㈣㈤㈥㈦㈧㈨㈩ⅠⅡⅢⅣⅤⅥⅦⅧⅨⅩⅪⅫぁあぃいぅうぇえぉおかがきぎくぐけげこごさざしじすずせぜそぞただちぢっつづてでとどなにぬねのはばぱひびぴふぶぷへべぺほぼぽまみむめもゃやゅゆょよらりるれろゎわゐゑをんァアィイゥウェエォオカガキギクグケゲコゴサザシジスズセゼソゾタダチヂッツヅテデトドナニヌネノハバパヒビピフブプヘベペホボポマミムメモャヤュユョヨラリルレロヮワヰヱヲンヴヵヶΑΒΓΔΕΖΗΘΙΚΛΜΝΞΟΠΡΣΤΥΦΧΨΩαβγδεζηθ ικλμνξοπρστυφχψ ω︵︶︹︺︿﹀︽︾﹁﹂﹃﹄︻
|
|
select gms_output.get_lines('{lines}',3);
|
|
get_lines
|
|
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|
|
("{""[131231321312313,wrewerwr,werwerw},{dhsfsdjfsdf]"",""∵∴∷♂♀°℃＄¤￠￡‰§№☆*〇○*◎** 回□*△▽⊿▲▼▁▂▃▄▆**▉▊▋▌▍▎▏※→←↑↓↖↗↘↙** ⅰⅱⅲⅳⅴⅵⅶⅷⅸⅹ①②③④⑤⑥⑦⑧⑨⑩⒈⒉⒊⒋ ⒌⒍⒎⒏⒐⒑⒒⒓⒔⒕⒖⒗⒘⒙⒚⒛⑴⑵⑶⑷⑸⑹⑺⑻⑼⑽⑾⑿⒀⒁⒂⒃⒄⒅⒆⒇㈠㈡㈢㈣㈤㈥㈦㈧㈨㈩ⅠⅡⅢⅣⅤⅥⅦⅧⅨⅩⅪⅫぁあぃいぅうぇえぉおかがきぎくぐけげこごさざしじすずせぜそぞただちぢっつづてでとどなにぬねのはばぱひびぴふぶぷへべぺほぼぽまみむめもゃやゅゆょよらりるれろゎわゐゑをんァアィイゥウェエォオカガキギクグケゲコゴサザシジスズセゼソゾタダチヂッツヅテデトドナニヌネノハバパヒビピフブプヘベペホボポマミムメモャヤュユョヨラリルレロヮワヰヱヲンヴヵヶΑΒΓΔΕΖΗΘΙΚΛΜΝΞΟΠΡΣΤΥΦΧΨΩαβγδεζηθ ικλμνξοπρστυφχψ ω︵︶︹︺︿﹀︽︾﹁﹂﹃﹄︻""}",2)
|
|
(1 row)
|
|
|
|
begin
|
|
gms_output.enable(100);
|
|
gms_output.PUT_LINE('{[131231321312313,wrewerwr,werwerw]},{dhsfsdjfsdf]},{美丽泸沽湖}');
|
|
end;
|
|
/
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: SQL statement "CALL gms_output.enable(100)"
|
|
PL/pgSQL function inline_code_block line 2 at PERFORM
|
|
{[131231321312313,wrewerwr,werwerw]},{dhsfsdjfsdf]},{美丽泸沽湖}
|
|
select gms_output.get_lines('{lines}',3);
|
|
get_lines
|
|
------------------------------------------------------------------------------
|
|
("{""{[131231321312313,wrewerwr,werwerw]},{dhsfsdjfsdf]},{美丽泸沽湖}""}",1)
|
|
(1 row)
|
|
|
|
--设置v_data为int形式
|
|
declare
|
|
v_data text[];
|
|
v_numlines number;
|
|
begin
|
|
gms_output.enable(100);
|
|
gms_output.put_line('好好学习');
|
|
gms_output.put_line('天天向上');
|
|
gms_output.put_line('oh ye');
|
|
v_numlines:=3;
|
|
gms_output.get_lines(v_data,v_numlines);
|
|
for v_counter in 1..v_numlines loop
|
|
gms_output.put_line(v_data(v_counter));
|
|
end loop;
|
|
end;
|
|
/
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: SQL statement "CALL gms_output.enable(100)"
|
|
PL/pgSQL function inline_code_block line 4 at PERFORM
|
|
好好学习
|
|
天天向上
|
|
oh ye
|
|
好好学习
|
|
天天向上
|
|
oh ye
|
|
select gms_output.get_lines('{lines}',3);
|
|
get_lines
|
|
-------------------------------------
|
|
("{好好学习,天天向上,""oh ye""}",3)
|
|
(1 row)
|
|
|
|
select gms_output.get_lines(3);
|
|
ERROR: function gms_output.get_lines(integer) does not exist
|
|
LINE 1: select gms_output.get_lines(3);
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_lines
|
|
select gms_output.get_lines('aaaa');
|
|
ERROR: function gms_output.get_lines(unknown) does not exist
|
|
LINE 1: select gms_output.get_lines('aaaa');
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_lines
|
|
select gms_output.get_lines();
|
|
ERROR: function gms_output.get_lines() does not exist
|
|
LINE 1: select gms_output.get_lines();
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_lines
|
|
select gms_output.get_lines(0);
|
|
ERROR: function gms_output.get_lines(integer) does not exist
|
|
LINE 1: select gms_output.get_lines(0);
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_lines
|
|
select gms_output.get_lines(-1);
|
|
ERROR: function gms_output.get_lines(integer) does not exist
|
|
LINE 1: select gms_output.get_lines(-1);
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_lines
|
|
select gms_output.get_lines(-1.666);
|
|
ERROR: function gms_output.get_lines(numeric) does not exist
|
|
LINE 1: select gms_output.get_lines(-1.666);
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_lines
|
|
select gms_output.get_lines('-1.666');
|
|
ERROR: function gms_output.get_lines(unknown) does not exist
|
|
LINE 1: select gms_output.get_lines('-1.666');
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_lines
|
|
select gms_output.get_lines(null);
|
|
ERROR: function gms_output.get_lines(unknown) does not exist
|
|
LINE 1: select gms_output.get_lines(null);
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_lines
|
|
select gms_output.get_lines({123432});
|
|
ERROR: syntax error at or near "{"
|
|
LINE 1: select gms_output.get_lines({123432});
|
|
^
|
|
select gms_output.get_lines('{123432}');
|
|
ERROR: function gms_output.get_lines(unknown) does not exist
|
|
LINE 1: select gms_output.get_lines('{123432}');
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_lines
|
|
select gms_output.get_lines(3);
|
|
ERROR: function gms_output.get_lines(integer) does not exist
|
|
LINE 1: select gms_output.get_lines(3);
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_lines
|
|
select gms_output.get_lines('a');
|
|
ERROR: function gms_output.get_lines(unknown) does not exist
|
|
LINE 1: select gms_output.get_lines('a');
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_lines
|
|
select gms_output.get_lines(null);
|
|
ERROR: function gms_output.get_lines(unknown) does not exist
|
|
LINE 1: select gms_output.get_lines(null);
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_lines
|
|
select gms_output.get_lines(power(2,31));
|
|
ERROR: function gms_output.get_lines(double precision) does not exist
|
|
LINE 1: select gms_output.get_lines(power(2,31));
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_lines
|
|
select gms_output.get_lines(3,99);
|
|
ERROR: function gms_output.get_lines(integer, integer) does not exist
|
|
LINE 1: select gms_output.get_lines(3,99);
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_lines
|
|
select gms_output.get_lines();
|
|
ERROR: function gms_output.get_lines() does not exist
|
|
LINE 1: select gms_output.get_lines();
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_lines
|
|
select gms_output.GET_LINES('{hhh}',1);
|
|
get_lines
|
|
-----------
|
|
({},0)
|
|
(1 row)
|
|
|
|
select gms_output.get_lines('{123432}',3);
|
|
get_lines
|
|
-----------
|
|
({},0)
|
|
(1 row)
|
|
|
|
select gms_output.get_lines('{123432}','{12312312}');
|
|
ERROR: invalid input syntax for integer: "{12312312}"
|
|
LINE 1: select gms_output.get_lines('{123432}','{12312312}');
|
|
^
|
|
CONTEXT: referenced column: get_lines
|
|
select gms_output.get_lines('{入户为了未来}',1);
|
|
get_lines
|
|
-----------
|
|
({},0)
|
|
(1 row)
|
|
|
|
select gms_output.get_lines('{入户为了未来}','1');
|
|
get_lines
|
|
-----------
|
|
({},0)
|
|
(1 row)
|
|
|
|
select gms_output.get_lines('{入户为了未来}','hhh');
|
|
ERROR: invalid input syntax for integer: "hhh"
|
|
LINE 1: select gms_output.get_lines('{入户为了未来}','hhh');
|
|
^
|
|
CONTEXT: referenced column: get_lines
|
|
select gms_output.get_lines('{}','');
|
|
get_lines
|
|
-----------
|
|
({},0)
|
|
(1 row)
|
|
|
|
select gms_output.get_lines(null,null);
|
|
get_lines
|
|
-----------
|
|
({},0)
|
|
(1 row)
|
|
|
|
select gms_output.get_lines('','');
|
|
get_lines
|
|
-----------
|
|
({},0)
|
|
(1 row)
|
|
|
|
select gms_output.get_lines(0,0);
|
|
ERROR: function gms_output.get_lines(integer, integer) does not exist
|
|
LINE 1: select gms_output.get_lines(0,0);
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_lines
|
|
--#61857668 [Oracle - gms_output.get_lines] Not support gms_output.chararr type
|
|
SET search_path to gms_output;
|
|
create table tt(aa int,bb varchar2(100));
|
|
ERROR: relation "tt" already exists in schema "gms_output"
|
|
DETAIL: creating new table with existing name in the same schema
|
|
declare
|
|
lines gms_output.chararr;
|
|
v_numlines number;
|
|
begin
|
|
gms_output.put_line('line one');
|
|
gms_output.put_line('line two');
|
|
gms_output.new_line();
|
|
gms_output.put_line('line three');
|
|
v_numlines := 4;
|
|
gms_output.get_lines(lines, v_numlines);
|
|
for v_counter in 1..v_numlines loop
|
|
insert into tt values(v_counter, lines(v_counter));
|
|
gms_output.put_line(lines(v_counter));
|
|
end loop;
|
|
end;
|
|
/
|
|
line one
|
|
line two
|
|
line three
|
|
line one
|
|
line two
|
|
line three
|
|
--查看结果
|
|
select * from tt;
|
|
aa | bb
|
|
----+------------
|
|
0 | This
|
|
0 | end
|
|
1 | line one
|
|
2 | line two
|
|
3 |
|
|
4 | line three
|
|
(6 rows)
|
|
|
|
DECLARE
|
|
lines GMSOUTPUT_LINESARRAY;
|
|
v_numlines number;
|
|
begin
|
|
--gms_output.put('This ');
|
|
--gms_output.put('is ');
|
|
gms_output.put_line('line one');
|
|
gms_output.put_line('line two');
|
|
gms_output.new_line();
|
|
--gms_output.put('end.');
|
|
gms_output.put_line('line three');
|
|
v_numlines := 4;
|
|
gms_output.get_lines(lines, v_numlines);
|
|
for v_counter in 1..v_numlines loop
|
|
insert into tt values(v_counter, lines(v_counter));
|
|
gms_output.put_line(lines(v_counter));
|
|
end loop;
|
|
end;
|
|
/
|
|
ERROR: type "gmsoutput_linesarray" does not exist
|
|
LINE 1: DECLARE lines GMSOUTPUT_LINESARRAY;
|
|
^
|
|
QUERY: DECLARE lines GMSOUTPUT_LINESARRAY;
|
|
v_numlines number;
|
|
begin
|
|
--gms_output.put('This ');
|
|
--gms_output.put('is ');
|
|
gms_output.put_line('line one');
|
|
gms_output.put_line('line two');
|
|
gms_output.new_line();
|
|
--gms_output.put('end.');
|
|
gms_output.put_line('line three');
|
|
v_numlines := 4;
|
|
gms_output.get_lines(lines, v_numlines);
|
|
for v_counter in 1..v_numlines loop
|
|
insert into tt values(v_counter, lines(v_counter));
|
|
gms_output.put_line(lines(v_counter));
|
|
end loop;
|
|
end
|
|
--查看结果
|
|
select * from tt;
|
|
aa | bb
|
|
----+------------
|
|
0 | This
|
|
0 | end
|
|
1 | line one
|
|
2 | line two
|
|
3 |
|
|
4 | line three
|
|
(6 rows)
|
|
|
|
--#61857707 [Oracle - gms_output.get_lines] Accept with only one parameter
|
|
select gms_output.put_line('line one');
|
|
line one
|
|
put_line
|
|
----------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.put_line('line two');
|
|
line two
|
|
put_line
|
|
----------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.new_line();
|
|
new_line
|
|
----------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.put_line('line three');
|
|
line three
|
|
put_line
|
|
----------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.get_lines(4);
|
|
ERROR: function gms_output.get_lines(integer) does not exist
|
|
LINE 1: select gms_output.get_lines(4);
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_lines
|
|
select gms_output.get_lines('{0}',4);
|
|
get_lines
|
|
-------------------------------------------------------
|
|
("{""line one"",""line two"","""",""line three""}",4)
|
|
(1 row)
|
|
|
|
--执行存储过程
|
|
declare
|
|
lines varchar[];
|
|
v_numlines number;
|
|
begin
|
|
--gms_output.put('This ');
|
|
--gms_output.put('is ');
|
|
gms_output.put_line('line one');
|
|
gms_output.put_line('line two');
|
|
gms_output.new_line();
|
|
--gms_output.put('end.');
|
|
gms_output.put_line('line three');
|
|
v_numlines := 4;
|
|
gms_output.get_lines(4);
|
|
for v_counter in 1..v_numlines loop
|
|
insert into tt values(v_counter, lines(v_counter));
|
|
gms_output.put_line(lines(v_counter));
|
|
end loop;
|
|
end;
|
|
/
|
|
ERROR: function gms_output.get_lines has no enough parameters
|
|
CONTEXT: compilation of PL/pgSQL function "inline_code_block" near line 11
|
|
--查看结果
|
|
select * from tt;
|
|
aa | bb
|
|
----+------------
|
|
0 | This
|
|
0 | end
|
|
1 | line one
|
|
2 | line two
|
|
3 |
|
|
4 | line three
|
|
(6 rows)
|
|
|
|
--清理资源
|
|
drop table tt;
|
|
-- test gms_output.new_line
|
|
select gms_output.put('This ');
|
|
This
|
|
put
|
|
-----
|
|
|
|
(1 row)
|
|
|
|
select gms_output.new_line;
|
|
new_line
|
|
----------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.new_line();
|
|
new_line
|
|
----------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.new_line(null);
|
|
ERROR: function gms_output.new_line(unknown) does not exist
|
|
LINE 1: select gms_output.new_line(null);
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: new_line
|
|
select gms_output.new_line('');
|
|
ERROR: function gms_output.new_line(unknown) does not exist
|
|
LINE 1: select gms_output.new_line('');
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: new_line
|
|
select gms_output.new_line('hhh');
|
|
ERROR: function gms_output.new_line(unknown) does not exist
|
|
LINE 1: select gms_output.new_line('hhh');
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: new_line
|
|
select gms_output.new_line('""where,where"". :???????');
|
|
ERROR: function gms_output.new_line(unknown) does not exist
|
|
LINE 1: select gms_output.new_line('""where,where"". :???????');
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: new_line
|
|
select gms_output.new_line(systime);
|
|
ERROR: column "systime" does not exist
|
|
LINE 1: select gms_output.new_line(systime);
|
|
^
|
|
CONTEXT: referenced column: new_line
|
|
select gms_output.new_line(8888);
|
|
ERROR: function gms_output.new_line(integer) does not exist
|
|
LINE 1: select gms_output.new_line(8888);
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: new_line
|
|
select gms_output.new_line('Time Started: ' || TO_CHAR('2001-09-28 01:00:00'::timestamp, 'DD-MON-YYYY HH24:MI:SS'));
|
|
ERROR: function gms_output.new_line(text) does not exist
|
|
LINE 1: select gms_output.new_line('Time Started: ' || TO_CHAR('2001...
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: new_line
|
|
select gms_output.new_line（88889）;
|
|
ERROR: missing FROM-clause entry for table "gms_output"
|
|
LINE 1: select gms_output.new_line（88889）;
|
|
^
|
|
CONTEXT: referenced column: new_line（88889）
|
|
begin
|
|
gms_output.ENABLE(100);
|
|
gms_output.put('This ');
|
|
gms_output.put('is ');
|
|
gms_output.new_line();
|
|
end;
|
|
/
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: SQL statement "CALL gms_output.enable(100)"
|
|
PL/pgSQL function inline_code_block line 2 at PERFORM
|
|
This
|
|
is
|
|
select gms_output.GET_LINE();
|
|
ERROR: function gms_output.get_line() does not exist
|
|
LINE 1: select gms_output.GET_LINE();
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: get_line
|
|
-- test gms_output.put
|
|
select gms_output.put('This ');
|
|
This
|
|
put
|
|
-----
|
|
|
|
(1 row)
|
|
|
|
select gms_output.put();
|
|
ERROR: function gms_output.put() does not exist
|
|
LINE 1: select gms_output.put();
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: put
|
|
select gms_output.put(null);
|
|
put
|
|
-----
|
|
|
|
(1 row)
|
|
|
|
select gms_output.put('');
|
|
put
|
|
-----
|
|
|
|
(1 row)
|
|
|
|
select gms_output.put(-999888,pppp);
|
|
ERROR: column "pppp" does not exist
|
|
LINE 1: select gms_output.put(-999888,pppp);
|
|
^
|
|
CONTEXT: referenced column: put
|
|
select gms_output.put(1,21);
|
|
ERROR: function gms_output.put(integer, integer) does not exist
|
|
LINE 1: select gms_output.put(1,21);
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: put
|
|
select gms_output.put(123213123);
|
|
123213123
|
|
put
|
|
-----
|
|
|
|
(1 row)
|
|
|
|
select gms_output.put('未来更快更高更强','hsdufdsnjfs','shfusdfjfjs',12313213);
|
|
ERROR: function gms_output.put(unknown, unknown, unknown, integer) does not exist
|
|
LINE 1: select gms_output.put('未来更快更高更强','hsdufdsnjfs','shfu...
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: put
|
|
select gms_output.put('@#￥#@@#！@#！#￥@%%');
|
|
@#￥#@@#！@#！#￥@%%
|
|
put
|
|
-----
|
|
|
|
(1 row)
|
|
|
|
select gms_output.put(2017-09-23);
|
|
1985
|
|
put
|
|
-----
|
|
|
|
(1 row)
|
|
|
|
select gms_output.put(2017-09-23 12:23:29);
|
|
ERROR: syntax error at or near "12"
|
|
LINE 1: select gms_output.put(2017-09-23 12:23:29);
|
|
^
|
|
select gms_output.put(89%);
|
|
ERROR: syntax error at or near ")"
|
|
LINE 1: select gms_output.put(89%);
|
|
^
|
|
select gms_output.put(’あ@ ‘);
|
|
ERROR: column "’あ" does not exist
|
|
LINE 1: select gms_output.put(’あ@ ‘);
|
|
^
|
|
CONTEXT: referenced column: put
|
|
select gms_output.put(2000/07/99);
|
|
2.88600288600289
|
|
put
|
|
-----
|
|
|
|
(1 row)
|
|
|
|
select gms_output.put(power(2,32));
|
|
4294967296
|
|
put
|
|
-----
|
|
|
|
(1 row)
|
|
|
|
select gms_output.put(power(2,9999));
|
|
ERROR: value out of range: overflow
|
|
CONTEXT: referenced column: put
|
|
select gms_output.put('Time Started: ' || TO_CHAR('2001-09-28 01:00:00'::timestamp, 'DD-MON-YYYY HH24:MI:SS'));
|
|
Time Started: 28-SEP-2001 01:00:00
|
|
put
|
|
-----
|
|
|
|
(1 row)
|
|
|
|
select gms_output.put(あ@ 、iohgfvcs大富大贵);
|
|
ERROR: column "あ" does not exist
|
|
LINE 1: select gms_output.put(あ@ 、iohgfvcs大富大贵);
|
|
^
|
|
CONTEXT: referenced column: put
|
|
select gms_output.put('、。·ˉˇ¨〃々—～‖…〔〕〈〉《》「」『』〖〗【】±＋－×÷∧∨∑∏∪∩∈√⊥∥∠⌒⊙∫∮≡≌≈∽∝≠≮≯≤≥∞∶ ∵∴∷♂♀°℃＄¤￠￡‰§№☆*〇○*◎** 回□*△▽⊿▲▼▁▂▃▄▆**▉▊▋▌▍▎▏※→←↑↓↖↗↘↙** ⅰⅱⅲⅳⅴⅵⅶⅷⅸⅹ①②③④⑤⑥⑦⑧⑨⑩⒈⒉⒊⒋ ⒌⒍⒎⒏⒐⒑⒒⒓⒔⒕⒖⒗⒘⒙⒚⒛⑴⑵⑶⑷⑸⑹⑺⑻⑼⑽⑾⑿⒀⒁⒂⒃⒄⒅⒆⒇㈠㈡㈢㈣㈤㈥㈦㈧㈨㈩ⅠⅡⅢⅣⅤⅥⅦⅧⅨⅩⅪⅫ！＃￥％＆（）＊＋，－．／０１２３４５６７８９：；＜＝＞？＠ＡＢＣＤＥＦＧＨＩＪＫＬＭＮＯＰＱＲＳＴＵＶＷＸＹＺ［＼］＾＿｀ａｂｃｄｅｆｇｈｉｊｋｌｍｎｏｐｑｒｓｔｕｖｗｘｙｚ｛｜｝ぁあぃいぅうぇえぉおかがきぎくぐけげこごさざしじすずせぜそぞただちぢっつづてでとどなにぬねのはばぱひびぴふぶぷへべぺほぼぽまみむめもゃやゅゆょよらりるれろゎわゐゑをんァアィイゥウェエォオカガキギクグケゲコゴサザシジスズセゼソゾタダチヂッツヅテデトドナニヌネノハバパヒビピフブプヘベペホボポマミムメモャヤュユョヨラリルレロヮワヰヱヲンヴヵヶΑΒΓΔΕΖΗΘΙΚΛΜΝΞΟΠΡΣΤΥΦΧΨΩαβγδεζηθ ικλμνξοπρστυφχψ ω︵︶︹︺︿﹀︽︾﹁﹂﹃﹄︻');
|
|
、。·ˉˇ¨〃々—～‖…〔〕〈〉《》「」『』〖〗【】±＋－×÷∧∨∑∏∪∩∈√⊥∥∠⌒⊙∫∮≡≌≈∽∝≠≮≯≤≥∞∶ ∵∴∷♂♀°℃＄¤￠￡‰§№☆*〇○*◎** 回□*△▽⊿▲▼▁▂▃▄▆**▉▊▋▌▍▎▏※→←↑↓↖↗↘↙** ⅰⅱⅲⅳⅴⅵⅶⅷⅸⅹ①②③④⑤⑥⑦⑧⑨⑩⒈⒉⒊⒋ ⒌⒍⒎⒏⒐⒑⒒⒓⒔⒕⒖⒗⒘⒙⒚⒛⑴⑵⑶⑷⑸⑹⑺⑻⑼⑽⑾⑿⒀⒁⒂⒃⒄⒅⒆⒇㈠㈡㈢㈣㈤㈥㈦㈧㈨㈩ⅠⅡⅢⅣⅤⅥⅦⅧⅨⅩⅪⅫ！＃￥％＆（）＊＋，－．／０１２３４５６７８９：；＜＝＞？＠ＡＢＣＤＥＦＧＨＩＪＫＬＭＮＯＰＱＲＳＴＵＶＷＸＹＺ［＼］＾＿｀ａｂｃｄｅｆｇｈｉｊｋｌｍｎｏｐｑｒｓｔｕｖｗｘｙｚ｛｜｝ぁあぃいぅうぇえぉおかがきぎくぐけげこごさざしじすずせぜそぞただちぢっつづてでとどなにぬねのはばぱひびぴふぶぷへべぺほぼぽまみむめもゃやゅゆょよらりるれろゎわゐゑをんァアィイゥウェエォオカガキギクグケゲコゴサザシジスズセゼソゾタダチヂッツヅテデトドナニヌネノハバパヒビピフブプヘベペホボポマミムメモャヤュユョヨラリルレロヮワヰヱヲンヴヵヶΑΒΓΔΕΖΗΘΙΚΛΜΝΞΟΠΡΣΤΥΦΧΨΩαβγδεζηθ ικλμνξοπρστυφχψ ω︵︶︹︺︿﹀︽︾﹁﹂﹃﹄︻
|
|
put
|
|
-----
|
|
|
|
(1 row)
|
|
|
|
select gms_output.put('123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890
|
|
');
|
|
ERROR: buffer overflow
|
|
DETAIL: Buffer overflow, limit of 2000 bytes
|
|
HINT: Increase buffer size in gms_output.enable() next time
|
|
CONTEXT: referenced column: put
|
|
select gms_output.put('** ⅰⅱⅲⅳⅴⅵⅶⅷⅸⅹ①②③④⑤⑥⑦⑧⑨⑩⒈⒉⒊⒋ ⒌⒍⒎⒏⒐⒑⒒⒓⒔⒕⒖⒗⒘⒙⒚⒛⑴⑵⑶⑷⑸⑹⑺⑻⑼⑽⑾⑿⒀⒁⒂⒃⒄⒅⒆⒇㈠㈡㈢㈣㈤㈥㈦㈧㈨㈩ⅠⅡⅢⅣⅤⅥⅦⅧⅨⅩⅪⅫ！＃￥％＆（）＊＋，－．／０１２３４５６７８９：；＜＝＞？＠ＡＢＣＤＥＦＧＨＩＪＫＬＭＮＯＰＱＲＳＴＵＶＷＸＹＺ［＼］＾＿｀ａｂｃｄｅｆｇｈｉｊｋｌｍｎｏｐｑｒｓｔｕｖｗｘｙｚ｛｜｝ぁあぃいぅうぇえぉおかがきぎくぐけげこごさざしじすずせぜそぞただちぢっつづてでとどなにぬねのはばぱひびぴふぶぷへべぺほぼぽまみむめもゃやゅゆょよらりるれろゎわゐゑをんァアィイゥウェエォオカガキギクグケゲコゴサザシジスズセゼソゾタダチヂッツヅテデトドナニヌネノハバパヒビピフブプヘベペホボポマミムメモャヤュユョヨラリルレロヮワヰヱヲンヴヵヶΑΒΓΔΕΖΗΘΙΚΛΜΝΞΟΠΡΣΤΥΦΧΨΩαβγδεζηθ ικλμνξοπρστυφχψ ω︵︶︹︺︿﹀︽︾﹁﹂﹃﹄︻');
|
|
** ⅰⅱⅲⅳⅴⅵⅶⅷⅸⅹ①②③④⑤⑥⑦⑧⑨⑩⒈⒉⒊⒋ ⒌⒍⒎⒏⒐⒑⒒⒓⒔⒕⒖⒗⒘⒙⒚⒛⑴⑵⑶⑷⑸⑹⑺⑻⑼⑽⑾⑿⒀⒁⒂⒃⒄⒅⒆⒇㈠㈡㈢㈣㈤㈥㈦㈧㈨㈩ⅠⅡⅢⅣⅤⅥⅦⅧⅨⅩⅪⅫ！＃￥％＆（）＊＋，－．／０１２３４５６７８９：；＜＝＞？＠ＡＢＣＤＥＦＧＨＩＪＫＬＭＮＯＰＱＲＳＴＵＶＷＸＹＺ［＼］＾＿｀ａｂｃｄｅｆｇｈｉｊｋｌｍｎｏｐｑｒｓｔｕｖｗｘｙｚ｛｜｝ぁあぃいぅうぇえぉおかがきぎくぐけげこごさざしじすずせぜそぞただちぢっつづてでとどなにぬねのはばぱひびぴふぶぷへべぺほぼぽまみむめもゃやゅゆょよらりるれろゎわゐゑをんァアィイゥウェエォオカガキギクグケゲコゴサザシジスズセゼソゾタダチヂッツヅテデトドナニヌネノハバパヒビピフブプヘベペホボポマミムメモャヤュユョヨラリルレロヮワヰヱヲンヴヵヶΑΒΓΔΕΖΗΘΙΚΛΜΝΞΟΠΡΣΤΥΦΧΨΩαβγδεζηθ ικλμνξοπρστυφχψ ω︵︶︹︺︿﹀︽︾﹁﹂﹃﹄︻
|
|
put
|
|
-----
|
|
|
|
(1 row)
|
|
|
|
create table tt(aa int,bb varchar2(100));
|
|
declare
|
|
v_line varchar2(100);
|
|
v_status integer := 0;
|
|
begin
|
|
gms_output.enable(100);
|
|
gms_output.put('This ');
|
|
gms_output.put('is ');
|
|
gms_output.new_line;
|
|
gms_output.put('end.');
|
|
gms_output.get_line(v_line, v_status);
|
|
while v_status = 0 loop
|
|
insert into tt values(v_status, v_line);
|
|
gms_output.get_line(v_line, v_status);
|
|
end loop;
|
|
end;
|
|
/
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: SQL statement "CALL gms_output.enable(100)"
|
|
PL/pgSQL function inline_code_block line 4 at PERFORM
|
|
This
|
|
is
|
|
end.
|
|
ERROR: value too long for type character varying(100)
|
|
CONTEXT: PL/pgSQL function inline_code_block line 9 at SQL statement
|
|
--清理资源
|
|
drop table tt;
|
|
-- test gms_output.put_line
|
|
select gms_output.PUT_LINE('......');
|
|
......
|
|
put_line
|
|
----------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.PUT_LINE(null);
|
|
put_line
|
|
----------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.PUT_LINE(131231321312313);
|
|
131231321312313
|
|
put_line
|
|
----------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.PUT_LINE('akfdskfsf??Oooo&&&^%**(');
|
|
akfdskfsf??Oooo&&&^%**(
|
|
put_line
|
|
----------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.PUT_LINE('');
|
|
put_line
|
|
----------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.PUT_LINE(89239432094%%&&*&&**&^);
|
|
ERROR: operator does not exist: bigint %%&&*&&**&^
|
|
LINE 1: select gms_output.PUT_LINE(89239432094%%&&*&&**&^);
|
|
^
|
|
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
|
|
CONTEXT: referenced column: put_line
|
|
select gms_output.PUT_LINE(-0.99923332);
|
|
-.99923332
|
|
put_line
|
|
----------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.PUT_LINE(power(2,31));
|
|
2147483648
|
|
put_line
|
|
----------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.PUT_LINE(max(2,3));
|
|
ERROR: function max(integer, integer) does not exist
|
|
LINE 1: select gms_output.PUT_LINE(max(2,3));
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: put_line
|
|
select gms_output.PUT_LINE('2001-09-28 01:00:00'::timestamp);
|
|
Fri Sep 28 01:00:00 2001
|
|
put_line
|
|
----------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.PUT_LINE(0);
|
|
0
|
|
put_line
|
|
----------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.PUT_LINE('adsfds');
|
|
adsfds
|
|
put_line
|
|
----------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.PUT_LINE(adsfds);
|
|
ERROR: column "adsfds" does not exist
|
|
LINE 1: select gms_output.PUT_LINE(adsfds);
|
|
^
|
|
CONTEXT: referenced column: put_line
|
|
select gms_output.PUT_LINE(power(2,9999));
|
|
ERROR: value out of range: overflow
|
|
CONTEXT: referenced column: put_line
|
|
select gms_output.PUT_LINE（power(2,9999)）;
|
|
ERROR: function gms_output.put_line（power(integer, integer) does not exist
|
|
LINE 1: select gms_output.PUT_LINE（power(2,9999)）;
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: ）
|
|
select gms_output.PUT_LINE(131231321312313,24232432);
|
|
ERROR: function gms_output.put_line(bigint, integer) does not exist
|
|
LINE 1: select gms_output.PUT_LINE(131231321312313,24232432);
|
|
^
|
|
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
CONTEXT: referenced column: put_line
|
|
select gms_output.PUT_LINE('疫情早日过去，国泰民安，风调雨顺，平安健康常在');
|
|
疫情早日过去，国泰民安，风调雨顺，平安健康常在
|
|
put_line
|
|
----------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.PUT_LINE('123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890
|
|
');
|
|
123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890
|
|
|
|
put_line
|
|
----------
|
|
|
|
(1 row)
|
|
|
|
select gms_output.PUT_LINE('** ⅰⅱⅲⅳⅴⅵⅶⅷⅸⅹ①②③④⑤⑥⑦⑧⑨⑩⒈⒉⒊⒋ ⒌⒍⒎⒏⒐⒑⒒⒓⒔⒕⒖⒗⒘⒙⒚⒛⑴⑵⑶⑷⑸⑹⑺⑻⑼⑽⑾⑿⒀⒁⒂⒃⒄⒅⒆⒇㈠㈡㈢㈣㈤㈥㈦㈧㈨㈩ⅠⅡⅢⅣⅤⅥⅦⅧⅨⅩⅪⅫ！＃￥％＆（）＊＋，－．／０１２３４５６７８９：；＜＝＞？＠ＡＢＣＤＥＦＧＨＩＪＫＬＭＮＯＰＱＲＳＴＵＶＷＸＹＺ［＼］＾＿｀ａｂｃｄｅｆｇｈｉｊｋｌｍｎｏｐｑｒｓｔｕｖｗｘｙｚ｛｜｝ぁあぃいぅうぇえぉおかがきぎくぐけげこごさざしじすずせぜそぞただちぢっつづてでとどなにぬねのはばぱひびぴふぶぷへべぺほぼぽまみむめもゃやゅゆょよらりるれろゎわゐゑをんァアィイゥウェエォオカガキギクグケゲコゴサザシジスズセゼソゾタダチヂッツヅテデトドナニヌネノハバパヒビピフブプヘベペホボポマミムメモャヤュユョヨラリルレロヮワヰヱヲンヴヵヶΑΒΓΔΕΖΗΘΙΚΛΜΝΞΟΠΡΣΤΥΦΧΨΩαβγδεζηθ ικλμνξοπρστυφχψ ω︵︶︹︺︿﹀︽︾﹁﹂﹃﹄︻');
|
|
ERROR: buffer overflow
|
|
DETAIL: Buffer overflow, limit of 2000 bytes
|
|
HINT: Increase buffer size in gms_output.enable() next time
|
|
CONTEXT: referenced column: put_line
|
|
drop database if exists testdb_utf8;
|
|
NOTICE: database "testdb_utf8" does not exist, skipping
|
|
create database testdb_utf8;
|
|
\c testdb_utf8;
|
|
create extension gms_output;
|
|
declare
|
|
a int := 10;
|
|
b varchar2(100) := 'abcdef';
|
|
c text := '测试用例，，，,,,.. ..。。。。';
|
|
begin
|
|
gms_output.enable(4000);
|
|
gms_output.put_line('test case');
|
|
gms_output.put_line('test case' || a);
|
|
gms_output.put_line('test case' || b);
|
|
gms_output.put_line('test case' || c);
|
|
gms_output.put_line('测试用例');
|
|
gms_output.put_line('测试用例，，，,ABCD,,....。。。。');
|
|
gms_output.put_line('测试用例，，，,ABCD,,....。。。。' || a);
|
|
gms_output.put_line('测试用例，，，,ABCD,,....。。。。' || b);
|
|
gms_output.put_line('测试用例，，，,ABCD,,....。。。。' || c);
|
|
end;
|
|
/
|
|
test case
|
|
test case10
|
|
test caseabcdef
|
|
test case测试用例，，，,,,.. ..。。。。
|
|
测试用例
|
|
测试用例，，，,ABCD,,....。。。。
|
|
测试用例，，，,ABCD,,....。。。。10
|
|
测试用例，，，,ABCD,,....。。。。abcdef
|
|
测试用例，，，,ABCD,,....。。。。测试用例，，，,,,.. ..。。。。
|
|
\c contrib_regression
|
|
drop database testdb_utf8;
|
|
drop database if exists testdb_gbk;
|
|
NOTICE: database "testdb_gbk" does not exist, skipping
|
|
create database testdb_gbk encoding='GBK' LC_COLLATE='C' LC_CTYPE='C';
|
|
\c testdb_gbk
|
|
create extension gms_output;
|
|
set client_encoding to 'UTF8';
|
|
declare
|
|
a int := 10;
|
|
b varchar2(100) := 'abcdef';
|
|
c text := '测试用例，，，,,,.. ..。。。。';
|
|
begin
|
|
gms_output.enable(4000);
|
|
gms_output.put_line('test case');
|
|
gms_output.put_line('test case' || a);
|
|
gms_output.put_line('test case' || b);
|
|
gms_output.put_line('test case' || c);
|
|
gms_output.put_line('测试用例');
|
|
gms_output.put_line('测试用例，，，,ABCD,,....。。。。');
|
|
gms_output.put_line('测试用例，，，,ABCD,,....。。。。' || a);
|
|
gms_output.put_line('测试用例，，，,ABCD,,....。。。。' || b);
|
|
gms_output.put_line('测试用例，，，,ABCD,,....。。。。' || c);
|
|
end;
|
|
/
|
|
test case
|
|
test case10
|
|
test caseabcdef
|
|
test case测试用例，，，,,,.. ..。。。。
|
|
测试用例
|
|
测试用例，，，,ABCD,,....。。。。
|
|
测试用例，，，,ABCD,,....。。。。10
|
|
测试用例，，，,ABCD,,....。。。。abcdef
|
|
测试用例，，，,ABCD,,....。。。。测试用例，，，,,,.. ..。。。。
|
|
reset client_encoding;
|
|
\c contrib_regression
|
|
drop database testdb_gbk;
|
|
-- test gms_output.serveroutput
|
|
set search_path=gms_output_test;
|
|
begin
|
|
gms_output.put('123');
|
|
gms_output.put_line('abc');
|
|
end;
|
|
/
|
|
begin
|
|
gms_output.enable(4000);
|
|
gms_output.put('123');
|
|
gms_output.new_line();
|
|
gms_output.put_line('abc');
|
|
end;
|
|
/
|
|
123
|
|
abc
|
|
begin
|
|
gms_output.put('222');
|
|
gms_output.new_line();
|
|
end;
|
|
/
|
|
222
|
|
begin
|
|
gms_output.enable(4000);
|
|
gms_output.put_line('abc');
|
|
end;
|
|
/
|
|
abc
|
|
begin
|
|
gms_output.disable();
|
|
gms_output.enable(4000);
|
|
gms_output.put('456');
|
|
gms_output.put('7');
|
|
gms_output.new_line();
|
|
gms_output.put('89');
|
|
gms_output.put_line('abc');
|
|
end;
|
|
/
|
|
456
|
|
7
|
|
89
|
|
abc
|
|
begin
|
|
gms_output.disable();
|
|
gms_output.enable(4000);
|
|
gms_output.new_line();
|
|
gms_output.put('456');
|
|
gms_output.put('7');
|
|
gms_output.put('89');
|
|
gms_output.put_line('abc');
|
|
gms_output.put_line('fff');
|
|
gms_output.put_line('ggg');
|
|
end;
|
|
/
|
|
456
|
|
7
|
|
89
|
|
abc
|
|
fff
|
|
ggg
|
|
begin
|
|
gms_output.enable();
|
|
gms_output.put_l ine('abc');
|
|
end;
|
|
/
|
|
ERROR: syntax error at or near "ine"
|
|
LINE 3: gms_output.put_l ine('abc');
|
|
^
|
|
QUERY: DECLARE
|
|
BEGIN gms_output.enable();
|
|
gms_output.put_l ine('abc');
|
|
end
|
|
begin
|
|
gms_output.put('123');
|
|
gms_output.new_line();
|
|
end;
|
|
/
|
|
123
|
|
begin
|
|
gms_output.put('123');
|
|
end;
|
|
/
|
|
123
|
|
begin
|
|
gms_output.new_line();
|
|
end;
|
|
/
|
|
set gms_output.serveroutput to off;
|
|
show gms_output.serveroutput;
|
|
gms_output.serveroutput
|
|
-------------------------
|
|
off
|
|
(1 row)
|
|
|
|
begin
|
|
gms_output.put_line('2');
|
|
end;
|
|
/
|
|
2
|
|
begin
|
|
gms_output.enable(4000);
|
|
gms_output.put_line('abc');
|
|
end;
|
|
/
|
|
abc
|
|
set gms_output.serveroutput to on;
|
|
begin
|
|
gms_output.enable(4000);
|
|
gms_output.put('123');
|
|
gms_output.put_line('YYY');
|
|
end;
|
|
/
|
|
123
|
|
YYY
|
|
begin
|
|
gms_output.disable();
|
|
gms_output.enable(4000);
|
|
gms_output.put('33');
|
|
end;
|
|
/
|
|
33
|
|
begin
|
|
gms_output.put('44');
|
|
gms_output.new_line();
|
|
end;
|
|
/
|
|
44
|
|
create table gms_output_tt3(aa int,bb varchar2(100));
|
|
declare
|
|
v_line varchar2(100);
|
|
v_status integer := 0;
|
|
begin
|
|
gms_output.put_line('55');
|
|
gms_output.get_line(v_line, v_status);
|
|
insert into gms_output_tt3 values(v_status, v_line);
|
|
end;
|
|
/
|
|
55
|
|
select * from gms_output_tt3;
|
|
aa | bb
|
|
----+------
|
|
0 | 3344
|
|
(1 row)
|
|
|
|
begin
|
|
gms_output.ENABLE;
|
|
gms_output.put_line('This ');
|
|
end;
|
|
/
|
|
This
|
|
select gms_output.GET_LINE(0,1);
|
|
get_line
|
|
-------------
|
|
("This ",0)
|
|
(1 row)
|
|
|
|
begin
|
|
gms_output.enable(100);
|
|
gms_output.PUT_LINE('{131231321312313},{dhsfsdjfsdf}');
|
|
gms_output.PUT_LINE('{好还是打发士大夫},{dhsfsdjfsdf}');
|
|
end;
|
|
/
|
|
WARNING: Limit increased to 2000 bytes.
|
|
CONTEXT: SQL statement "CALL gms_output.enable(100)"
|
|
PL/pgSQL function inline_code_block line 2 at PERFORM
|
|
{131231321312313},{dhsfsdjfsdf}
|
|
{好还是打发士大夫},{dhsfsdjfsdf}
|
|
select gms_output.get_lines('{lines}',3);
|
|
get_lines
|
|
----------------------------------------------------------------------------------
|
|
("{""{131231321312313},{dhsfsdjfsdf}"",""{好还是打发士大夫},{dhsfsdjfsdf}""}",2)
|
|
(1 row)
|
|
|
|
reset search_path;
|
|
drop schema gms_output_test cascade;
|
|
NOTICE: drop cascades to table gms_output_test.gms_output_tt3
|