![]() |
Hello Everything,
08 Feb 2016
,
|
![]() |
Hi All,
28 Oct 2015
,
|
![]() |
I'm attempting to develop a stored procedure that takes a table name as a parameter, and performs column-by-column updates to whatever table is passed in. I have the dynamic SELECT query working correctly: SET CURSOR_SQL = 'SELECT * FROM ' || P_TABLE_NAME || ' ORDER BY rsid;'; Now I'm at the point where I need to fetch the cursor data into local variables...but I can't create table-specific local variables because I don't know what tables will be passed into this procedure.
01 Aug 2011
| 4 comments
,
|