The Artima Developer Community
Sponsored Link

Java Answers Forum
How to "setArray" into the PL/SQL stored procedure?

0 replies on 1 page.

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 0 replies on 1 page
Alex Shaw

Posts: 15
Nickname: alexhaha
Registered: Dec, 2002

How to "setArray" into the PL/SQL stored procedure? Posted: Mar 23, 2004 5:41 PM
Reply to this message Reply
Advertisement
CallableStatement cstmt = con.prepareCall(" { call CMPACKAGE.CM_P(?,?,?) } ");


I create a PL/SQL package.
////////////////
create or replace package CMPACKAGE is
//I declare a "Array_type" by myself.
Type Array_type is
Table Of Varchar2(20)
Index by Binary_Integer;

end CMPACKAGE;

/////////////////////////////
create or replace package body CMPACKAGE is

procedure CM_P( iArray_no in Array_type )
.......
end CM_P;

end CMPACKAGE;


So how can I pass a para String[] to the proc?

Topic: Leftmost Characters Previous Topic   Next Topic Topic: networking

Sponsored Links



Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use