skip to main
|
skip to sidebar
Search This Blog
Wednesday, April 15, 2009
ADF:Calling PLSQL Package using jdbc connection
ArrayList
rows = new ArrayList
();
private static String connectUrl = "jdbc:oracle:thin:@10.201.1.32:1521:XE";
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
con = DriverManager.getConnection(connectUrl, "HR", "oracle");
//Statement s = con.createStatement();
//ResultSet rs = s.executeQuery("Select * from employees");
//while (rs.next()){
//System.out.println(rs.getString(2)); //}
oracle.jdbc.OracleCallableStatement ocs = null;
oracle.sql.StructDescriptor structDesc = StructDescriptor.createDescriptor("EMP_REC", con);
oracle.sql.ArrayDescriptor arrayDesc = ArrayDescriptor.createDescriptor("EMP_TABLE", con);
ArrayList arr = new ArrayList();
String[] objName;
ListIterator LItr = rows.listIterator();
while (LItr.hasNext()) {
// objName=(String[])LItr.next();
// Object [] singleobj = {
// objName[0],objName[1],objName[2]
// };
oracle.sql.STRUCT p1struct = new STRUCT(structDesc, con, (Object[])LItr.next()); //singleobj);
arr.add(p1struct);
}
oracle.sql.ARRAY newArray = new ARRAY(arrayDesc, con, arr.toArray());
ocs =
//(OracleCallableStatement)con.prepareCall("begin PK_PROD.INSERT_PROD1; end;");
(OracleCallableStatement)con.prepareCall("begin PK_PROD.INSERT_PROD(:1); end;"); ocs.setARRAY(1, newArray);
ocs.execute();
con.commit();
con.close();
ocs.close();
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Blog Archive
►
2020
(2)
►
September
(2)
►
Sep 10
(1)
►
Sep 09
(1)
►
2010
(10)
►
September
(1)
►
Sep 16
(1)
►
March
(9)
►
Mar 12
(1)
►
Mar 11
(2)
►
Mar 08
(6)
▼
2009
(10)
►
November
(2)
►
Nov 21
(1)
►
Nov 04
(1)
►
October
(1)
►
Oct 30
(1)
►
May
(1)
►
May 25
(1)
▼
April
(6)
►
Apr 29
(1)
►
Apr 20
(1)
▼
Apr 15
(4)
ADF:Display Selected table row
ADF:Calling PLSQL Package using jdbc connection
Changing view Objects & refreshing coresponding co...
ADF Page Load event & post back
►
2008
(7)
►
November
(1)
►
Nov 01
(1)
►
October
(2)
►
Oct 29
(1)
►
Oct 18
(1)
►
September
(2)
►
Sep 15
(1)
►
Sep 06
(1)
►
August
(2)
►
Aug 25
(2)
About Me
Dixon
View my complete profile
Followers
No comments:
Post a Comment