Hi,
I have a process which inserts data (8000 lines) into a table from another table. When I run the page, it takes 5 mn processing and after that I get an error. The error I get is 500 : Internal server error. And the table :P74_TABLE is not populated with the data coming from the table TELEVERSEMENT. The script is PL/SQL code:
DECLARE
X VARCHAR2 (2000) ;
BEGIN
X := 'INSERT INTO '||:P74_TABLE||'
SELECT '||:P74_CLEF_VAR||', DATE1, VALEUR
FROM TELEVERSEMENT';
execute immediate X ;
END ;
The error I get is 500 : Internal server error. And the table :P74_TABLE is not populated with the data coming from the table TELEVERSEMENT.
Why does it take so long time ? If i try with SQL developer the copy is almost immediate.
Regards,
Christian