Calling stored procedure using JDBC driver

From: John Sinues <sinues_at_pinn.net>
Date: 5 May 1998 19:17:35 GMT
Message-ID: <6inokf$fno_at_netaxs.com>

I'm having trouble calling an Oracle stored procedure using the thin JDBC driver using JBuilder 1.01.

Here's a brief description of the stored procedure and the Java code used to call it.

Oracle stored procedure definition:
CREATE OR REPLACE PROCEDURE get_user_data(   u_sn OUT NUMBER, ut_sn OUT NUMBER, u_uic OUT VARCHAR2) AS BEGIN
:
:

END; Java code:

    String SQLString = "{ call get_user_data(?,?,?) }";     CallableStatement cs = null;

    try {

	  // connectionString 
          //  = jdbc:oracle:thin:_at_database IP:SQL*Net port:database name
        Connection conn = DriverManager.getConnection( 
             connectionString, username, password );
        System.out.println( "...connection created" );
        cs = conn.prepareCall( SQLString );

        System.out.println( "...prepare" );

        cs.registerOutParameter( 1, java.sql.Types.INTEGER );
        cs.registerOutParameter( 2, java.sql.Types.INTEGER );
        cs.registerOutParameter( 3, java.sql.Types.VARCHAR );

        System.out.println( "...variables registered" );

        cs.execute(); // < **** DIES HERE **** >
        ResultSet stmtResultSet = cs.getResultSet();
        while(stmtResultSet.next()) {
          System.out.println(String.valueOf(stmtResultSet.getObject(1)));
          System.out.println(String.valueOf(stmtResultSet.getObject(2)));
          System.out.println(String.valueOf(stmtResultSet.getObject(3)));
        }

    }
    catch ( Exception exception ) {

        Message msg = new Message( new Frame(),
                    "Get User Info Error",
                    exception.getMessage() );

        msg.setVisible(true);

    }

On cs.execute(), I receive the following error message:

ORA 06550: line 1, column 7
PLS 00201: identifieer 'GET_USER_DATA' must be declared
ORA 06550: line 1 column 7, PL/SQL: statement ignored

TIA,
^john Received on Tue May 05 1998 - 21:17:35 CEST