Hi All,
I'm having this issue on one of my reports during runtime, and even on the reports builder unit test
REP-1401: A fatal PL/SQL error occured in program unit XXX
ORA-32767: No server connection for this operation
Database: 10g R2
Reports Builder 11.2.2.0
Recently I migrated reports from 10g to 11g.
I found an actual "workaround", I quote it because I have a feeling that it could be the solution, turns out that the funtion that fails has the below code on the very first lines.
function CF_ADJ_CODE_DESC_CHKFormula return Char is
--i varchar2(9);
l_adj_desc abc.ft_lookups.attribute10%type;
l_adj_desc_g abc.ft_lookups.attribute10%type;
--l_code VARCHAR2(9):=:adjustment_code1||'A';
--l_code_desc VARCHAR2(600) := NULL;
l_code_desc clob := NULL;
l_header varchar2(1) := 'N';
begin
... [Validations, etc]
RETURN (substr(l_code_desc, 1, 4000));
... [Exception handling]
end:;
if I change the CLOB for VARCHAR2(32000) it works!
function CF_ADJ_CODE_DESC_CHKFormula return Char is
--i varchar2(9);
l_adj_desc abc.ft_lookups.attribute10%type;
l_adj_desc_g abc.ft_lookups.attribute10%type;
--l_code VARCHAR2(9):=:adjustment_code1||'A';
--l_code_desc VARCHAR2(600) := NULL;
-- l_code_desc clob := NULL;
l_code_desc VARCHAR2(32000);
l_header varchar2(1) := 'N';
begin
... [Validations, etc]
RETURN (substr(l_code_desc, 1, 4000));
... [Exception handling]
end;
Question is, does Oracle Reports no longer support CLOB datatype on any function?
if so, where I can found those Oracle notes that can back me up.