       p_first_column_is_template => true);
   end generate_text;
 
+
+  procedure generate_text(
+    p_stmt in clob,
+    p_result out varchar2,
+    p_delimiter in varchar2 default null) 
+  as
+    l_row_tab row_tab;
+  begin
+    copy_table_to_row_tab(
+      p_stmt => p_stmt,
+      p_row_tab => l_row_tab,
+      p_first_column_is_template => true);
+
+    bulk_replace(
+      p_template => null,
+      p_row_tab => l_row_tab,
+      p_delimiter => p_delimiter,
+      p_result => p_result,
+      p_first_column_is_template => true);
+  end generate_text;
+
+
+  procedure generate_text(
+    p_stmt in clob,
+    p_result out dbms_sql.varchar2a,
+    p_delimiter in varchar2 default null) 
+  as
+    l_row_tab row_tab;
+  begin
+    copy_table_to_row_tab(
+      p_stmt => p_stmt,
+      p_row_tab => l_row_tab,
+      p_first_column_is_template => true);
+
+    bulk_replace(
+      p_template => null,
+      p_row_tab => l_row_tab,
+      p_delimiter => p_delimiter,
+      p_result => p_result,
+      p_first_column_is_template => true);
+  end generate_text;
+
+
+  function generate_text(
+    p_stmt in clob,
+    p_delimiter in varchar2 default null) 
+    return varchar2 
+  as
+    l_string varchar2(32767);
+  begin
+    generate_text(
+      p_stmt => p_stmt,
+      p_result => l_string,
+      p_delimiter => p_delimiter);
+    return l_string;
+  end generate_text;
+
+
+  function generate_text(
+    p_cursor in sys_refcursor,
+    p_delimiter in varchar2 default null) 
+    return varchar2 
+  as
+    l_string varchar2(32767);
+    l_cur sys_refcursor := p_cursor;
+  begin
+    generate_text(
+      p_cursor => l_cur,
+      p_result => l_string,
+      p_delimiter => p_delimiter);
+    return l_string;
+  end generate_text;
+
+
 begin
   initialize;
 end code_generator;

      p_cursor => p_cursor,
      p_row_tab => l_row_tab,
      p_first_column_is_template => true);
    
    bulk_replace(
      p_template => null,
      p_row_tab => l_row_tab,

   */
  procedure open_cursor(
    p_cur out integer,
    p_cursor in out nocopy sys_refcursor) 
  as
  begin
    p_cur := dbms_sql.to_cursor_number(p_cursor);
  end open_cursor;


  /* Prozedur zum Analysieren eines Cursor
   * %param p_cur ID des Cursors
   * %param p_cur_desc DBMS_SQL.DESC_TAB2 mit den Details zu einem Cursor
