Hi,

I'm trying to call a PostgreSQL function that returns a string,
but I get only the first character of the returned string !?!

Does anyone has a hint how to resolve this problem?

Johann

this is my  test-code:

--Postgres:----------------------------------------------------

CREATE OR REPLACE FUNCTION get_string()
    RETURNS text
    LANGUAGE 'plpgsql'
AS $BODY$
 BEGIN
  RETURN 'myText';
 END;
$BODY$;

--local external functions section in my transaction-object----------------

function string get_string() RPCFUNC

---PB-Script ---------------------------------------------------

string ls_text
//ls_text = space(256)
ls_text =  sqlca.get_string()
Messagebox("String", "The returned string is: " + ls_text)

-- the resulting Messagebox ---------------------------------------------------

---------------------------
String
---------------------------
The returned string is: m
---------------------------
OK  
---------------------------