On which line do you get ORA-03113? Usually, "ORA-03113 end-of-file on comnunication chanel" indicates that there might be something wrong with the database profile settings. The Oracle process or SQL*Net connection died in a middle. To execute multiple commands you should use PL/SQL blocks like "BEGIN xxx_proc1; xxx_proc2; END;" Note that Oracle does not support DDL statements like ALTER, CREATE, and DROP in PL/SQL, however you can use DBMS_SQL package to execute such commands. : I am testing 24x7 2.3.6, Oracle 8.0.5.2.1 automatically compile the : procedures, but this software isn't. I need to compile on runtime couse : some procedures make drop and create tables and becomes uncompile after : run. Well, i tried to resolve it whit a Jal script i made a : databaseconnect("profile") : databaseexecute("alter procedure xxxx compile") : databaseexecute("execute procedure xxx") : at this time appear "ORA-03113 end-of-file on comnunication chanel" : that is very important for us, couse is the goal of this software to decide : to : buy it. : One more thing. I can't use multiple ORACLE SQL commands.
|