StringForever StringForever - 1 year ago 137
SQL Question

SQL can't insert linebreak with CHAR(13): no function with name 'char' exists

Please help me, it's disturbing, I'm trying to insert a simple line break. (Windows)

My PL/SQL code is:
DECLARE str varchar2(32767);
BEGIN str := 'A Text' + char(13) + char(10) + 'Next text';
INSERT INTO atable (...) (str);

I always get the error:

PLS-00222 no function with Name 'CHAR' exists in this scope

Answer Source

The function is CHR

e.g. -

select chr (65) from dual;

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download