Home » Developer & Programmer » JDeveloper, Java & XML » registerOutParameter()  () 1 Vote
registerOutParameter() [message #109996] Wed, 02 March 2005 12:35 Go to next message
HH-HH
Messages: 1
Registered: March 2005
Junior Member
//if output from oracle procedure is an array of record Type

//how to take that output by calleableStatement?

CallableStatement cstmt = conn.prepareCall(sql);
cstmt.registerOutParameter(1, java.sql.Types.ARRAY, "TEST_RECORDS");
cstmt.execute();

Report message to a moderator

Re: registerOutParameter() [message #110114 is a reply to message #109996] Thu, 03 March 2005 09:57 Go to previous message
scott.swank
Messages: 14
Registered: March 2005
Location: Las Vegas
Junior Member
You'll have to use an Oracle JDBC driver. Look into oracle.sql.ARRAY. I just did a quick search on otn.oracle.com and this looks like a good starting point for you:

http://www.oracle.com/technology/tech/java/sqlj_jdbc/pdf/a96654.pdf

Report message to a moderator

Previous Topic: using defined db connection
Next Topic: Simple Stored procedure takes 3 minutes to fetch results
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 05:38:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.