HELP .... Please answer a simple question ... is it possible to call pl/sql from the oracle JDBCthin client ? (coredump)

From: Hank Griffioen <hank_at_daac.gsfc.nasa.gov>
Date: 1998/01/05
Message-ID: <68rs73$k7o@post.gsfc.nasa.gov>#1/1

why or why not ? ... I can not get it to work at all .... why does it core dump ?

If it is possible can someone send me a simple example ? ...

SOURCE ?>>> class select_person
{
  public static void main (String args [])

       throws SQLException, ClassNotFoundException   {
    // Load the Oracle JDBC driver

      Class.forName ("oracle.jdbc.driver.OracleDriver");
        Connection conn =

   DriverManager.getConnection (
   "jdbc:oracle:thin:@daacdev1.gsfc.nasa.gov:1521:eosdev2","scott", "tiger");

             CallableStatement statement;
         statement = conn.prepareCall("{call select_person(?,?,?)}");
             statement.setInt(1, 3);
         statement.registerOutParameter (2, Types.VARCHAR);
         statement.registerOutParameter (3, Types.VARCHAR);
             statement.execute();
         System.out.println (" Output plsql firstname " +statement.getString


(2));

         System.out.println (" Output plsql lastname " +statement.getString


(3));

         statement.close();
     }

}

plsql>java select_person
SIGBUS 10* bus error

    si_signo [10]: SIGBUS    10*  bus error
    si_errno [0]: Error 0
    si_code [1]: BUS_ADRERR [addr: 0x1]
        stackbase=7FFFAE78, stackpointer=7FFF9AB8

Full thread dump:

    "Async I/O Poll thread" (TID:0xab3268, sys_thread_t:0x26e0da0, state:CW) prio=11

    "Finalizer thread" (TID:0xab3220, sys_thread_t:0x26a0da0, state:CW) prio=1

    "Async Garbage Collector" (TID:0xab31d8, sys_thread_t:0x2660da0, state:CW) prio=1

    "Idle thread" (TID:0xab3190, sys_thread_t:0x2620da0, state:R) prio=0
    "Clock" (TID:0xab30d0, sys_thread_t:0x25e0da0, state:CW) prio=12
    "main" (TID:0xab30a8, sys_thread_t:0x1003ee08, state:R) prio=5 *current

thread*
Monitor Cache Dump:

    oracle.jdbc.driver.OracleCallableStatement_at_AB7CC8/B04578: owner "main"
(0x1003ee08, 1 entry)

    <unknown key> (0x2660da0): <unowned>

        Waiting to be notified:
            "Async Garbage Collector"

Registered Monitor Dump:

    Thread queue lock: <unowned>
    Class lock: <unowned>
    Name and type hash table lock: <unowned>     String intern lock: <unowned>
    JNI pinning lock: <unowned>
    JNI global reference lock: <unowned>     BinClass lock: <unowned>
    Class loading lock: <unowned>
    Java stack lock: <unowned>
    Code rewrite lock: <unowned>
    Heap lock: <unowned>
    Has finalization queue lock: <unowned>     Finalize me queue lock: <unowned>

        Waiting to be notified:
            "Finalizer thread"
    Async IO Poll lock: <unowned>
        Waiting to be notified:
            "Async I/O Poll thread"

    hostent lock: <unowned>
    Malloc lock: <unowned>
    Monitor IO lock: <unowned>
    Child death monitor: <unowned>
    Event monitor: <unowned>
    I/O monitor: <unowned>
    Alarm monitor: <unowned>

        Waiting to be notified:
            "Clock"

    Sbrk lock: <unowned>
    Monitor cache expansion lock: <unowned>     Monitor registry: owner "main" (0x1003ee08, 1 entry) Thread Alarm Q:

    sys_thread_t 0x2660da0 [Timeout in 377 ms] Abort(coredump)

Thanks Received on Mon Jan 05 1998 - 00:00:00 CST