returning result set from Java Stored Procedures on Oracle

**asundaram** · 01-21-2003 04:53 PM

I want to write a Java Stored Procedure that will select rows from a database and return multiple rows to a Java application. I'm using Oracle 9i and eventualy I want to be able to place my Java Stored Procs. on a SYbase database as well w/o making any modifications to it.
Is returning rows from a Java stored proc. possible? If so, how can it be written/published?
Thanks.

**Pankaj** · 01-30-2003 06:53 AM

Hi,

here are some pointers to get you started:

1) include java.sql.* package - it contains the classes for the functionality you are seeking.

2) Create a "Connection" object for the database you are connecting to.

3) Create a "Statement" object for the operation you want to perform on the database.

4) Execute the statement and the object returned is "Resultset".

All the classes mentioned above have a rich mulitude of methods to suit your requirements.

There is a tutorial on Sun's website for JDBC which explains all the essential steps for using DB in java.

Hope this helps.

**Jigs** · 03-31-2004 09:39 AM

Hi,

I am currently tryig to write java code in order to get results from my pl/sql stored procedure. But so far i am not succesfull. I wil post my code. Maybe someone can help me.

Code:

<%@ page import="java.sql.*" %>
<%@ page import= "java.lang.*" %>
<%

String melding = "--Geen--";




 

// Executes the stored procedure.

//try

//{  
  java.sql.Connection myConnection = DriverManager.getConnection("jdbc:oracle:thin:@192.168.10.109:1521:ABZ","abz","abz");
   String strQuery = "{call Procedure.ABZ.CNT_VKE(?)}";
  CallableStatement cs = myConnection.prepareCall(strQuery);
  cs.registerOutParameter(1, Types.VARCHAR);
  cs.execute();
  //String resultSet = (String)cs.getString(1);

    System.out.println(cs.getString(2));
    System.out.println(cs.getString(3));
    //System.out.println(cs.getDouble(4));


  //ResultSet resultSet = (ResultSet)cs.getObject(1);

//  String outParam = cs.getString(1);     // OUT parameter

 /*if (cs.execute())

 {
   //cs.execute();
   //ResultSet rs = cs.getResultSet(cs);
   //String test= cs.getString(p_param);
   melding = "Uitgevoerd";

   }
 }

catch (java.sql.SQLException sqle)

{

   melding = sqle.toString();

}*/

%>

<html>

<head>

<LINK REL=STYLESHEET TYPE="text/css" HREF="bc4j.css">

<TITLE>Browse Form</TITLE>

</head>

<body>

<h1>Testpage</h1>

<% 

  out.println("Query uitgevoerd:" + melding + "
");

 // out.println( cs.execute() );

%>

</body>

</html>

THNX

Thread: returning result set from Java Stored Procedures on Oracle

Thread Tools

Display

returning result set from Java Stored Procedures on Oracle

Bookmarks

Bookmarks

Posting Permissions