Its the very basics to go through stack trace and trying to find out what error it is before posting it in a forum.
This works perfectly well from weblogic domain in my local system but fails in the weblogic domain on the actual application machine... I read about some drivers issue related to Oracle 10g and wanted to know if anybody in here had faced something like that....
User Profile
Collapse
-
Protocol violation, Bigger than maximum error
Hi
The highlighted below is the sample code I used for calling my stored procedure.
Callable statement cstmt = conn.prepareCal l( BEGIN STOREDPROCNAME( ?,?,?);END;);
ArrayDescriptor arrayDescriptor = new ArrayDescriptor (Name of type,cstmt.getC onnection());
ARRAY acctList = new ARRAY(arrayDesc riptor,conn, flrList.toArray ());
cstmt.setInt(1, 10);
... -
Class cast exception
The following is a piece of code to calla stored procedure in oracle from java
ArrayList arrList = new ArrayList();
arrList.add(new Integer("10"));
arrList.add(new Integer("7"));
cstmt = conn.prepareCal l("BEGIN PRM_SMART_FIXTU RE_SEQ1(?,?,?); END;");
ArrayDescriptor arrayDescriptor = new ArrayDescriptor (
"FLOORPLAN_LABE L_LIST",... -
SIMPLE but SLOW SELECT query!!!
Hi,
I have the following query which is running very slow
SELECT D.STORE_FACILIT Y_ID,D.PRIMARY_ ACCT_NUM FROM DS_STORE D
WHERE D.PRIMARY_ACCT_ NUM IN(SELECT W.COMPONENT1_ID FROM WK_FILTER_CMPNT W
WHERE W.COMPONENT1_ID = 1)FOR FETCH ONLY
can anyone help?
No activity results to display
Show More
Leave a comment: