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.