>HI,
>I would like to fill varchar variable with values of all columns of a single row. Once I get this row, I can do something like :
>
>myColumnsValues VARCHAR2(2048);
>BEGIN
> myColumnsValues :=
> EXECUTE IMMEDIATE('INSERT INTO MY TABLE(myList) VALUES (:1)' USING myColumnsValues;
>END;
>
>Is there a package (dbms_sql) that can do it or another way to get all values into a single variable ?
>
>Thank you for your help,
>Christian Cote

Hi!
Check out DESCRIBE_COLUMNS in DBMS_SQL
Here's an example:

http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a76936/dbms_sq2.htm#1004872

Of course you'll have to work it through.