[Orclib-users] ??: [Bulk] how to pass a varray of varchar2 to oracle database using ocilib

[Xun C. <ch...@av...>]

 
Hi Vincent,

Thanks for your reply.
But I found that the function OCI_ElemSetString() always returns false.

It returns false when performing the check of 
     OCI_CHECK(str    == NULL, FALSE);
in line 664 of the source file string.c.

Best regards,
Xun

________________________________

???: vin...@gm... [mailto:vin...@gm...] ?? vincent
rogier
????: 2009?11?9? ??? 18:05
???: Xun Chen
??: Re: [Bulk] [Orclib-users] how to pass a varray of varchar2 to oracle
database using ocilib


Hi Xun,

there is a error in your code.

It should be :



	/* .. */
	
	type    = OCI_TypeInfoGet(conn, "string_array20", OCI_TIF_TYPE);
	vchars = OCI_CollCreate(type);
	elem   = OCI_ElemCreate(type);
	
	for (i=0; i<n; i++) {
	   OCI_ElemSetString(elem, s[i]));
	   OCI_CollAppend(vchars, elem);
	 }
	
	/* .. */
	

Regards,

Vincent


2009/11/9 Xun Chen <ch...@av...>



	Hi,
	
	I want to call a procedure which take a varray of varchar2 as a in
parameter.
	As a test, I write the following code to set the data
	
	 OCI_Coll  * vchars;
	 OCI_Elem * elem;
	 OCI_TypeInfo *type;
	 char s[5][64];
	 int n;
	 strcpy(s[0], "2009-01-04 11:22:15");
	 strcpy(s[1], "2009-03-14 01:12:25");
	 strcpy(s[2], "2009-04-24 11:42:35");
	 strcpy(s[3], "2009-05-04 21:52:45");
	 strcpy(s[4], "2009-06-04 13:32:55");
	   ....
	   n=5;
	 type = OCI_TypeInfoGet(conn, "string_array20", OCI_TIF_TYPE);
	 vchars = OCI_CollCreate(type);
	 for (i=0; i<n; i++) {
	   elem = OCI_ElemCreate(type);
	   OCI_ElemSetColl(elem, vchars);
	   OCI_ElemSetString(elem, s[i]));
	   OCI_CollAppend(vchars, elem);
	 }
	
	where string_array20 is defined by following pl/sql statement:
	create type string_array20 is varray(20) of varchar2(64);
	
	Run the code show following message:
	Elements are not compatible.
	
	It seems that I should not use OCI_ElemSetString() here. If so, what
should I do to pass
	 such a data type to the database?
	
	Best regards,
	Xun
	
	
	
----------------------------------------------------------------------------
--
	Let Crystal Reports handle the reporting - Free Crystal Reports 2008
30-Day
	trial. Simplify your report design, integration and deployment - and
focus on
	what you do best, core application coding. Discover what's new with
	Crystal Reports now.  http://p.sf.net/sfu/bobj-july
	_______________________________________________
	Orclib-users mailing list
	Orc...@li...
	https://lists.sourceforge.net/lists/listinfo/orclib-users
	




-- 
Vincent Rogier