Please Suggest : PL/SQL: ORA-00947: not enough values
Hello Experts,
I am wriding small peice of Code which inserts the data from a Cursor variable into a table. I am stuck with the below error,
10/6 PL/SQL: SQL Statement ignored
10/18 PL/SQL: ORA-00947: not enough values
The Code is as below
CREATE OR REPLACE PROCEDURE INSERT_TEMP
IS
RC <PackageName>.RETURN_CURSOR;TYPE tabobj IS TABLE OF OBJ_INSERT%ROWTYPE;tab tabobj;BEGINFETCH RC BULK COLLECT INTO tab;CLOSE RC;FOR J IN 1..tab.COUNT LOOPINSERT INTO OBJ_INSERT VALUES(tab(J));END LOOP;END;Could you please suggest what is the flaw in the code that is causing this error. The table I created (Obj_insert) has enough columns as the data that my ref cursor is fetching from the package. I cross verified that by printing the refcursor by using PRINT RC;