2010-05-27

Can you fix the bug in the following code?

Here is the code:

begin
FOR c_d
IN (SELECT *
FROM table_a
)
LOOP
c_d.id := NULL;

INSERT INTO table_a values (c_d);
END LOOP;
end;


this gives an ORA-00947: not enough values
in the line of "INSERT INTO table_a values (c_d);"

How to fix it?



.

.
.
.
.
.
.
.
.
.
Take the parenthesis out!
INSERT INTO table_a values c_d;

No comments:

Post a Comment

Os comentários são moderados.
The comments are moderated.