Hi We are not using any framework, it is just plain Java 1.4 API
Thanks Rasheed On Tue, Jul 28, 2009 at 9:59 PM, Arne <arne.christm...@googlemail.com>wrote: > > What kind of persistence framework are you using in java? > > On 28 Jul., 17:54, Rasheed Ali <d.rasheed....@gmail.com> wrote: > > CREATE OR REPLACE PACKAGE getUserInfo AS > > > > type rec_msg is record > > ( > > userId VARCHAR2(30), > > userRoles VARCHAR2(2000), > > userGroups VARCHAR2(2000), > > ); > > > > Procedure proc_get_user_details (Application_id IN VARCHAR2, > Prec_user_info > > OUT type rec_msg is record ) ; > > END getUserInfo; > > / > > > > CREATE OR REPLACE PACKAGE BODY getUserInfo AS > > > > Procedure proc_get_user_details (Application_id IN VARCHAR2, > Prec_user_info > > OUT type rec_msg is record ) > > AS > > BEGIN > > --Our Application Functionality > > --Assingn the derived data to the reord type > > Prec_user_info.userId := 'XYZ'; > > Prec_user_info. userRoles := 'ABC'; > > Prec_user_info.u userGroups := 'ZZZZ'; > > END > > END getUserInfo; > > / > > > > In the above package i able to execute in the Oracle serverside but while > > calling from Java.. it is thorowing invalid Column type. In the Java we > > mapped to ARRAY type while calling the same. > > > > Then I have changed the parameter to sql object type as > > > > CREATE OR REPLACE TYPE rec_msg AS OBJECT > > ( > > userId VARCHAR2(30), > > userRoles VARCHAR2(2000), > > userGroups VARCHAR2(2000), > > ); > > > > CREATE OR REPLACE TYPE tab_msg AS TABLE OF rec_msg; > > / > > > > Currently It is working Now. But my requirement is always need to send > the > > one row with three columns so Please advice me any other way to pass only > > record type to Java rather Array and what is the exact Java datatype to > map > > it the same? > > > > Thanks in Advance > > > > Rasheed > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
