[Oracle] "CREATE JAVA SOURCE" via ODBC?

Discussion in 'Java' started by Wojciech Maruszek, Sep 27, 2003.

  1. 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?
     
    Wojciech Maruszek, Sep 27, 2003
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Michael J. Moore

    ODBC to Oracle (data source name not found)

    Michael J. Moore, Jul 21, 2003, in forum: Python
    Replies:
    0
    Views:
    1,339
    Michael J. Moore
    Jul 21, 2003
  2. Bob Gailer
    Replies:
    0
    Views:
    500
    Bob Gailer
    Jul 21, 2003
  3. Nagendra
    Replies:
    0
    Views:
    265
    Nagendra
    Sep 29, 2004
  4. Wes Gamble
    Replies:
    1
    Views:
    183
    Gerardo Santana Gómez Garrido
    Apr 5, 2006
  5. Feyruz
    Replies:
    4
    Views:
    2,340
    Sherm Pendley
    Oct 14, 2005
Loading...

Share This Page