Call oracle function with return

[fabiojsantosdev]

I need to get the return when executing this Oracle PL/SQL block, but the result is empty. When I execute this block in sqldeveloper I can print the return on the screen.

import Database from "@IOC:Adonis/Lucid/Database";

export default async function HandleSendMsgRca(nummpedrca: any) {

try {
    const trx = await Database.transaction();

    const result = await trx.rawQuery(`
    DECLARE

    RESULT VARCHAR2(1);

    BEGIN

    result:= FNC_ENVIA_MSG_PED_RCA(${nummpedrca}) ;
    
    DBMS_OUTPUT.PUT_LINE('Retorno: ' || result);

    END;
    `,);

    console.log(result);
} catch (error) {
    console.log(error);
}

}