g_colName is a string of column names that I build earlier in the algorithm. My
problem is how do I do the 'INTO' part of this cursor, since I do not know how many or
of what type my columns are. The query is on the fly and totally dynamic.
Anyway to do this without using DBMS_SQL package?
OPEN cur_values FOR 'SELECT '||g_colName ||
' FROM ' || p_sourceSchema||'.'||v_tableName ||
' WHERE PARENT_RESOURCE_ID BETWEEM :1 AND :2'
USING p_startResourceID, p_endResourceID;
LOOP
FETCH cur_values
INTO v_values;
EXIT WHEN cur_values%NOTFOUND;
EXECUTE IMMEDIATE 'INSERT INTO '||p_targetSchema||'.'||v_tableName||
'('||g_colName||')'||
'(VALUES)';
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
