I am oracle 9i user .I want to link Ms excle work book in oracle database. Please send me some step by step help .I new user .
On 7/28/09, Rasheed Ali <d.rasheed....@gmail.com> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
