Re: [Oracle] "CREATE JAVA SOURCE" via ODBC?

On Sat, 27 Sep 2003 23:18:09 +0200, Wojciech Maruszek <wojciechmaruszek_at_wp.pl> wrote:

>Hello,
>
>I have an Oracle 9 database with ODBC drivers.
>I want to create a Java stored procedure.
>I have written the following statement:
>
> CREATE JAVA SOURCE NAMED SimpleClass AS
> public class SimpleClass
> {
> public static int is_positive(int number) {
> return (number >= 0) ? 1 : 0;
> }
> }
>
>The problem is that curly braces {} and question mark ?
>have special meaning for ODBC. My statement executes correctly
>when I switch to other drivers (like OCI). To make it work
>properly under ODBC, I have to modify Java source
>(e.g. replace ? : clauses with if's).
>
>Unfortunately, I have to stay with ODBC drivers.
>How to solve the problem?

Sorry but I don't see why you *have* to use ODBC drivers. ODBC lives on top of Oracle NET. If you have Oracle NET installed you likely also have sqlplus installed or isqlplus (web-interface) installed. You should be capable to use (i)sqlplus without problem. To only think of allowing anyone to create anything by means of ODBC and to use ODBC as a development 'tool' makes me shudder.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Sep 28 2003 - 00:30:03 CDT