dcsimg
Array in Oracle SPs and Java
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Kalyani_Gautam
Posted On:   Friday, February 1, 2002 10:26 AM

I created user defined type in Orcale TYPE inarray is TABLE OF VARCHAR2(500) and am using that as IN parm for my SP. I could successfully pass array from my java code and it does send array to the SP. My problem is that when I am creating arraydescriptior in Java code I have to prefix the owner of the schema name in Oracle to that type. ArrayDescriptor arraydesc = ArrayDescriptor.createDescriptor("INARRAY" , connection_obj); This INARRAY has to be prefixed with the schema owner name Else it gives me "invalid name pattern" error . Does anyone know how to overcome this ?    More>>

I created user defined type in Orcale



TYPE inarray is TABLE OF VARCHAR2(500)



and am using that as IN parm for my SP. I could successfully pass array from my java code and it does send array to the SP.


My problem is that when I am creating arraydescriptior in Java code I have to prefix the owner of the schema name in Oracle to that type.



ArrayDescriptor arraydesc = ArrayDescriptor.createDescriptor("INARRAY" , connection_obj);



This INARRAY has to be prefixed with the schema owner name
Else it gives me "invalid name pattern" error .

Does anyone know how to overcome this ?

   <<Less
About | Sitemap | Contact