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.

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.

I use the dbms_sql package. i tried with a databaseConnectEx and is the same error when execute the databaseExecute inmediatly appear the "ORA-03113 end-file...."

What is wrong with the profile

Do you use external identification?
Does the same command work in SQL*Plus?

: I use the dbms_sql package. i tried with a databaseConnectEx and is the same
: error when execute the databaseExecute inmediatly appear the
: "ORA-03113 end-file...."

: What is wrong with the profile

: Do you use external identification?
no i don't use it
: Does the same command work in SQL*Plus?
yes it works

I note that after those test, the task don't work ok never again, only with ODBC i can resolve it , but ODBC vs. Native driver is so poor the perfomance.

Try using Ora 7.3 driver for the connection. Please let us know if it will help.

Note that you can have as many different database profiles as you want.

: no i don't use it
: yes it works

: I note that after those test, the task don't work ok never again, only with
: ODBC i can resolve it , but ODBC vs. Native driver is so poor the
: perfomance.

yes it works!!!!

by now... I will let you know if something wrong appear again.

The Oracle 8xx drivers it seems has some bugs?

It uses different Oracle OCI files which in your case do not produce ORA-03113 errors.

: yes it works!!!!

: by now... I will let you know if something wrong appear again.

: The Oracle 8xx drivers it seems has some bugs?