I edit a function in the oracle
The function uf_is_text () return the char
The begin
Return the 'N';
End uf_is_text;


In PB so called
String ls_result

DECLARE generate_is_text PROCEDURE FOR uf_is_text ();
The Execute generate_is_text;
The Fetch generate_is_text Into: ls_result;
The Close generate_is_text;

Why the last ls_result value of "N" (N behind a pile of Spaces)

CodePudding user response:

Just tried it on, to solve by the varchar2 is normal,

CodePudding user response:

Oracle function you can write so
String ls_data

The select uf_is_text () into: ls_data from dual;

More convenient