Skip to Main Content
Forums

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

function parameter varchar2 not working

user-e43h0Jul 5 2023 — edited Jul 5 2023

Hi,

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…

Comments

Post Details

Added on Jul 5 2023
#database-connectivity-discussions, #java, #java-database-connectivity-jdbc, #oracle
1 comment
388 views