Home » Developer & Programmer » JDeveloper, Java & XML » java storedproc HELP
java storedproc HELP [message #91439] Thu, 05 September 2002 09:03 Go to next message
babu
Messages: 16
Registered: September 1999
Junior Member
hi all,

Iam using java stored procedures in oracle 8i
How can I return a java.sql.ResultSet to frontend (JSP file).
Is it possible or not?.If possible,
I want to know related datatype mapping for resultset
in PL/SQL.

CREATE OR REPLACE FUNCTION GET_LOCAL_RATE (Hotel_ID IN VARCHAR2,
ROOM_TYPE IN VARCHAR2, NATIONALITY_ID IN VARCHAR2)
RETURN ----------- AS
LANGUAGE JAVA NAME 'hotel.getLocalRate(java.lang.String,
java.lang.String,java.lang.String) return java.sql.ResultSet';

babu.
Re: java storedproc HELP [message #91440 is a reply to message #91439] Thu, 05 September 2002 10:31 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
refer this!
http://osi.oracle.com/~tkyte/ResultSets/index.html
Previous Topic: storing xml file in oracle9i
Next Topic: Re: Exception in thread "main" Java.lang.NoClassDefFoundError:dbas.
Goto Forum:
  


Current Time: Thu Mar 28 11:53:09 CDT 2024