nshanmugam's articles:

Items(2) /1

Dynamic table comparision issue 7 256 (2/22/2010 11:08:30 PM) comp.databases.oracle.server I'm trying to write a stored procedure which will compare two tables dynamically and will display the difference. The input parameter are two table names and columnames(optional) I get the column names fro... Sudhir

ERROR IS: ORA-01007: variable not in select list 5 899 (2/2/2010 12:13:30 AM) comp.databases.oracle.server I have a cursor inside a procedure which fetches some records using dynamic query. Now I need to insert these values into a table long with two more values, one is a unique ID and the other is testcase name.... Sudhir