| 
		
			| using OCI calls for the bind array [message #125144] | Thu, 23 June 2005 09:41 |  
			| 
				
				
					| tilokh Messages: 1
 Registered: June 2005
 Location: bangalore
 | Junior Member |  |  |  
	| All, I want following sql to be called with oci APIs,
 
 select a,b,c from table_1 where fld1 in (2,3,4,5,6,7,2,12,34,54,67,76);
 
 Here list value should be in the bind array ie.
 
 select a,b,c from table_1 where fld1 = :array_value
 
 where array_value [10] = {2,3,4,5,6,7,2,12,34,54....}
 
 Pl. do guide with sample code to achive this.
 
 Thanks in advanace
 William.
 |  
	|  |  |