Devart Forums

Hello everyone, my congratulations to this forum, my problem is that the request insert into doesn in pl sql dynamic and here's the code:

----------------------------------------------------------
OraSQL.SQL.Add('DECLARE');
OraSQL.SQL.Add(' i INTEGER;');
OraSQL.SQL.Add('BEGIN');
OraSQL.SQL.Add(' FOR i IN 0..10');
OraSQL.SQL.Add(' LOOP');
OraSQL.SQL.Add(' insert into dept(deptno,dname,loc)');
OraSQL.SQL.Add(' values(:p1,:p2,:p3)');
OraSQL.SQL.Add(' END LOOP;');
OraSQL.SQL.Add('END;');


OraSQL.ParamByName('p1').DataType := ftinteger;
OraSQL.ParamByName('p2').DataType := ftString;
OraSQL.ParamByName('p3').DataType := ftString;

OraSQL.ParamByName('p1').AsInteger := 19;
OraSQL.ParamByName('p2').AsString := 'nana';
OraSQL.ParamByName('p3').AsString := 'caca';

OraSQL.Execute;
---------------------------------------------------------------------


And the error is displayed

If you are happy help me.
Greetings.

Deptno is primary key in Dept table. So that you cannot insert 10 records with the same primary key value.

Hello thank you for your participation
But I changed the structure of the table dept to be without key primary, the error can be in the code structure or parameters you can test the script, please

I think it would be realy helpfull, if you would name the error

Please specify the error message that you have received.