Skip to Main Content

Java Programming


For appeals, questions and feedback, please email

function parameter varchar2 not working

user-e43h0Jul 5 2023


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…

Post Details
Added on Jul 5 2023