Re: Dynamic SQL select list

Steve wrote:
>
> I tried to get the columns supplied, parse them manually by comma and place
> them in a PL/SQL table,
> then iterate through the collection as follows:
>
> FOR d IN 1..v_indx LOOP --v_indx represents the count of the columns
> obtained
> DBMS_SQL.DEFINE_COLUMN(v_cursor_single,d,v_temp);
> END LOOP;
>
> The problem with that was I kept getting the:
>
> ORA-06550: line 50, column 9:
> PLS-00307: too many declarations of 'DEFINE_COLUMN' match this call
>
> error, for good reason.

Problem is that DBMS_SQL.DEFINE_COLUMN is overloaded. Try to use temp variables according to type of bind variable.

Greetings,

-- 
  -+==-.
   |   |                      |
   |==-+-=-+- -+===- -+==+- -=+==-         G o m b o s  B e r t a l a n
   |       |   |=-    |  '    |
  -|-=====-+- -+===-  |      -+==-          mailto:bgombos_at_freemail.hu
   '       '   '      '       '                 GSM:+36 20 9293612