Insert chinese characters to nclob column in plsql

36 Views Asked by At

I have a procedure and the text has chinese characters and has to be inserted into a table

create or replace procedure nclob_Test (text1 nclob)
as
begin
insert into abc123(nclobtext)
values (text1);
end;
/

TABLE

CREATE TABLE RESULTS.ABC123 ( NCLOBTEXT NCLOB );

DECLARE
    var_TEXT1   nclob;
BEGIN
    var_TEXT1 := '这不是杂志';
    RESULTS.NCLOB_TEST (TEXT1 => TO_NCLOB(var_TEXT1));

    COMMIT;
END;

The column is inserted as ¿¿¿¿¿

This input parameter is passed in from UI and they are unable to pass it as N'这不是杂志'

Is there a way that I can do this in the procedure.

0

There are 0 best solutions below