NLS-Problem with wwv_flow_utilities.blob_to_clob?
pinnomAug 4 2008 — edited Aug 5 2008Hi,
if I upload a file into a blob and convert it with wwv_flow_utilities.blob_to_clob I have problems with special characters. I think its a problem with my NLS_CHARACTERSET.
Here is the code to convert a file that is stored in APEX_APPLICATION_FILES to a CLOB:
declare
v_clob clob;
v_blob blob;
begin
SELECT blob_content into v_blob
FROM APEX_APPLICATION_FILES
where name = :P1_DATEIAUSWAHL;
delete APEX_APPLICATION_FILES
where name = :P1_DATEIAUSWAHL;
v_clob := wwv_flow_utilities.blob_to_clob(v_blob,'UTF8');
:P1_ANZEIGE := wwv_flow_utilities.clob_to_varchar2(v_clob);
end;
What is wrong there?
Regards,
Mark