am in an oracle 19 database with NLS_CHARACTERSET = WE8ISO8859P15 and I am executing a function (from an application that works on top of jdk 1.5 and Jboss 4.2.1) where I pass an object as a parameter that consists of numbers and varchar2 in this way
create or replace TYPE "ENVIOS" as object ( identificador NUMBER
, mes NUMBER
, precio NUMBER
, numero VARCHAR2( 100 )
, recibido NUMBER
but when inserting into the database, the numbers are inserted but the varchar2 parameter is not, it is inserted as empty.
I don't understand why it doesn't work, if I have it initialized with the size and everything. It seems that the tests lead to it being because of the type of character encoding. Can you help me, please? :( I do not know what else to do…