Gulab Singh

Greenhorn
+ Follow
since Aug 09, 2001
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Gulab Singh

I am trying to insall Japanese version of WebSphere 3.5 on AIX 4.3.3. The OS version is in English and it has got locales for JApanese installation. But there are no configurable parameters for specifying the language of the installation. WHen the install script is run it does not prompt for the language of installation. Can anyone help please.
19 years ago
The scrollable resultset is availble only in JDBC version 2.0, getFetchSize/setFetchSize methords are not supported by JDBC 1.1.x.
Check your version of JDBC.
Can someone please provide a sample JSP code for connecting to a Oracle 8i database using JDBC.
I am using tomcat server
Gulab
19 years ago
You can refer to following URL's for help. Also I am sure if you search on net you will get a ready made code for this. You need to define a datatype of CLOB/BLOB and then read the retrieved value into this variable using a method provided for CLOB/BLOB.
Also can you please send me the sample code which you used to connect to oracle database via JSP
you can reply at gulabs@delhi.tcs.co.in
Cheers,
Gulab
19 years ago
well, if you want to retrieve the rows in java, then declare the cursor as type REFCURSOR and then return that cursor. This can then be taken in a resultset.

Originally posted by Nimesh Gala:
i am a total newbie to Oracle and JDBC combination.
i have written a stored procedure that is expected to return multiple rows.
but when i execute it i get only the first row of it.
my procedure is
CREATE OR REPLACE Procedure SPGETOFFERSINGROUP
( parentId IN VARCHAR2)
IS
OFFID tbl_Offer_Level_Master.offer_id%type;
DES tbl_Offer_Group_Details.description%type;
BEGIN
SELECT tbl_Offer_Level_Master.offer_id, tbl_Offer_Group_Details.description
INTO OFFID, DES
FROM tbl_Offer_Level_Master, tbl_Offer_Group_Details
WHERE tbl_Offer_Level_Master.parent_id = tbl_Offer_Group_Details.offer_group_id
AND tbl_Offer_Level_Master.parent_id=parentId;

END;
this returns only the first record matching the crieteria,
how will i get all the rows?, do i have to use cursors, if so how?
what code is expected to be written in java to get the multiple records.
Define a cursor to fetch the rows. See the syntax for declaring and opening of the cursor then fetch the rows ome by one from the cursor. See a standard text book on oracle for syntax of declaring, opening and fetching of the cusrsor.
Thanks and Regards,
Gulab Singh
[This message has been edited by Nimesh Gala (edited August 11, 2001).]


IS anyone aware of an utility on UNIX(AIX) which facilitates creation of excel sheet from data extracted from oraclae 8i.
If yes does it provide custumization of visual attributes of the columns of the sheet.
Is there any other way i.e through JDBC/ODBC connection. I know through JDBC/ODBC we can select/update/delete the columns, but can be do the formatting of columns (Bold/font size etc..)
Thanks
Gulab