• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Can i use arryas with storedprocedures?if yes give me example.

 
sujitha reddy
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Can i use arryas with storedprocedures?if yes give me example.
ok, Thanks
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to the JDBC forum.
 
Nikhil Goel
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Arrays can be used in Stored Procedures . Oracle has a data type VARRAY that supports this .

Whole flow of usage is :-
-Define/Create a VARRAY of any primitive data type like integers/varchar2 in ORACLE .
-Use this VARRAY type as a INOUT type in the signature of SP .
-Set the Array type through any Statement object in JDBC .
-Manipulate this ARRAY in SP .
-Get the ARRAY back .

VARRAY is supported in ORACLE . DB2/Sybase have temp tables . SQL Server not sure
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic