sorupa

Greenhorn
+ Follow
since Dec 07, 2001
Merit badge: grant badges
For More
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 sorupa

I have written the stored procedure as follows using SYS_REFCURSOR.

CREATE OR REPLACE PROCEDURE fin_info (p_recordset1 OUT SYS_REFCURSOR,FINNO IN VARCHAR2)


AS
BEGIN

OPEN p_recordset1 FOR
SELECT NC_NAME ,RACE,DOB,GENDER,NAT,CONTACT_NUMBER,ENTRY_STATUS,ADDR_AS_IN_ID,CORRES_BLDG_NAME,
CORRES_BLK_HSE_NO,CORRES_STREET_NAME,CORRES_FLOOR_NO,CORRES_UNIT_NO,CORRES_POSTAL_CODE FROM
EIDS.TBL_EIS_NC WHERE FIN=FINNO ORDER BY CREATED_DT DESC ;

LOOP
FETCH p_recordset1 INTO NC_NAME, RACE,DOB,GENDER,NAT,CONTACT_NUMBER,ENTRY_STATUS,ADDR_AS_IN_ID,CORRES_BLDG_NAME,
CORRES_BLK_HSE_NO,CORRES_STREET_NAME,CORRES_FLOOR_NO,CORRES_UNIT_NO,CORRES_POSTAL_CODE;
EXIT WHEN p_recordset1%NOTFOUND;
DBMS_OUTPUT.PUT_LINE(NC_NAME || ' ' || RACE);
END LOOP;
CLOSE p_recordset1;

EXCEPTION
WHEN OTHERS THEN
raise_application_error(-20001,'An error was encountered (EIDS-FIN Information)- '||SQLCODE||' -ERROR- '||SQLERRM);
END fin_info;
/

grant execute on fin_info to tha_role;


call this procedure from the java program as follows.


cstmt = conn.prepareCall("{ ?=call THA.FIN_INFO(?) }");
System.out.println("FIN No...."+FINNo);
cstmt.registerOutParameter(1,OracleTypes.CURSOR);
cstmt.setString(2,FINNo);
cstmt.execute();
System.out.println("after Procedure..........");
//rs = (ResultSet)cstmt.getObject(1);
//while (rs.next ())
// System.out.println( rs.getString (1) );
cstmt.close();

getting the following error.


Oracle.DBException: java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 18:
PLS-00306: wrong number or types of arguments in call to 'FIN_INFO'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

pls help me to resolve the issues.
i'm trying to run my application in websphere4.0.
application is running.But the images are not loaded in my application.
Images are in Images folder.
calling my image is (/images/ss.gif).
But it's not able to show the image.if i calling the image using context root (ctx/images/ss.gif).
the image is loaded.what's solution for loading the image without using context root.
pls send me the answer.
21 years ago
We have a arraylist of arraylist which will fetch the value from the database and list the values in jsp page. The arraylist may contain various type of object and the size of the araylist of arraylist will be dynamic i.e will vary. Fro eg the arraylist may look like
[ [Suresh,20, 12/2/02, The test value],
[Xavier,26, 12/1/02, The test value with some other value],
[Varun,2, 1/2/02, The test value],
[Suba,24, 28/2/02, The test value],
]
The constraint is that that arraylist of arraylist must be sorted dynamically based on the datatypes ans well as the particular column.
for eg/ if i want to sort the given arraylist with respect to date value, The result of the sorted arraylist must contain the value based on the date and the order of the inner arraylist i.e the row value must not be changed.
Pls help me in solving the pbm.
thanx
Suba
22 years ago

we r doing a site in html.we need to display universal languages.
we have incorporated unicodes.it is working perfectly in html.
but in javascript it's not working.it's showing junk characters.
i have written one sample code.please help me in this.
<html>
<head>
<title></title>
</head>
<body>
<form>
ميزانية الحساب
<input type="text" onfocus="window.status = 'Enter the Payment Amount';return true;"
onChange="javascript:alert('ميزانية الحساب');" size="20"> <input type="text"
onfocus="window.status = 'Enter the Beneficiary Name';return true;"
onChange="javascript:call();" size="20">
ميزانية الحساب
</form>
<script LANGUAGE="javascript">
function call()
{
alert('ميزانية الحساب');
}
</script>
</body>
</html>

thanks