On Jul 28, 11:54 am, 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
Try to use Oracle Object type, it maps to Java oracle.sql.STRUCT http://download.oracle.com/docs/cd/B19306_01/java.102/b14355/oraint.htm#BABFGIAH http://download.oracle.com/docs/cd/B19306_01/java.102/b14355/oraoot.htm#i1039476 HTH Thomas --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
