| java storedproc HELP [message #91439] |
Thu, 05 September 2002 09:03  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
