QL>
SQL> declare
2 OLAP_progtext clob;
3 Result clob;
4 begin
5 OLAP_progtext:='define myaw.myhello program ';
6 OLAP_progtext:=OLAP_progtext||'program show ''HELLO'' end';
7 -- dbms_output.put_line(OLAP_progtext);
8 Result:=dbms_aw.interpclob(OLAP_progtext);
9 dbms_aw.printlog(Result);
10 end;
11 /

declare
OLAP_progtext clob;
Result clob;
begin
OLAP_progtext:='define myaw.myhello program ';
OLAP_progtext:=OLAP_progtext||'program show ''HELLO'' end';
-- dbms_output.put_line(OLAP_progtext);
Result:=dbms_aw.interpclob(OLAP_progtext);
dbms_aw.printlog(Result);
end;

ORA-35172: (SNCHILD01) There is duplicate information beginning at PROGRAM, or this information conflicts with a keyword.
ORA-06512: at "SYS.DBMS_AW", line 28
ORA-06512: at line 8

SQL>

Что делаю не так?.. :-)

DimaRпопробуй

OLAP_progtext:='define myaw.myhello program
';

т.е. перевод строки.
Именно! :-).. спасибо, большое!!! :-)