Simple JAVA STORED PROCEDURE WANT WORK...

From: Peter Valencic <peterv_at_in2.si>
Date: 20 Feb 2002 06:09:34 -0800
Message-ID: <16290d4d.0202200609.6c0506c1_at_posting.google.com>

I'am trying to insert some data into simple table which has 4 columns (id,name,surename,pwd). With Java I have created a simple class file:

-------------------------8< cut here
8<-----------------------------------

import java.util.*;
import java.sql.*;
import oracle.sql.*;
import oracle.jdbc.driver.*;

public class Osebe
{

/**
* This function insert a data into table */

public static void vnesiOsebo(int id,String ime,String priimek,String password)
{

  Connection conn;
  try
  {

      conn = new OracleDriver().defaultConnection();
      Statement stmt  =conn.createStatement();
      String sql="Insert into oseba (osb_id,priimek,ime,password)
values ("+id+",'"+priimek+"','"+ime+"','"+password+"')";
      ResultSet rs = stmt.executeQuery(sql);

  }
  catch(Exception e)
  {
  }
}
}

---

CREATE OR REPLACE PROCEDURE VNESI_OSEBO(p1 IN NUMBER, p2 IN VARCHAR2, p3 IN VARCHAR2, p4 IN VARCHAR2) AUTHID CURRENT_USER AS LANGUAGE JAVA NAME 'Osebe.vnesiOsebo(int, java.lang.String, java.lang.String,java.lang.String)';

---

I have deployed this into database... when I try to run the example:

DECLARE
  P1 NUMBER;

  P2 VARCHAR2(200);
  P3 VARCHAR2(200);
  P4 VARCHAR2(200);

BEGIN

  P1 := 44;
  P2 := 'rtrt';
  P3 := 'retewt';
  P4 := 'tertetet';

  ZAVRAZVOJ2.VNESI_OSEBO ( P1, P2, P3, P4 );   COMMIT;
END;

---

The function execute well but it does not insert any data into my table...

what is worng???
thnx for help

Peter Received on Wed Feb 20 2002 - 15:09:34 CET