Any Pl/SQL Guru's out there?

I'm trying to dynamically assign a value to a dynamic column. Very dynamic. :)

All seriousness though, here's what I am trying to do

table_rec.<dynamic_col> := SUBSTR(raw_rec.DATA, 1, 9);

Dynamic_Col is a value stored in the table, ie. Customer_Name. I know I can do this with update statements, but I don't want to have 25-30 updates per record.

I'm wondering if doing it this way is out of scope using DBMS_SQL

sql_string := 'SELECT SUBSTR(raw_rec.DATA, 1, 9) INTO table_rec.'||rec.col_name|| ' FROM DUAL;';

Where rec.col_name = Customer_name

Any help would be appreciated.

Thanks:

Naveed010_at_hotmail.com Received on Fri May 23 2003 - 17:05:06 CEST