String returned from oracle store procedure to Java with '???'
My code in Java call to store procedure in the Oracle DB and return object with some fields.
When I find out the attributes from the Object - I have problem with the string. The string became '???' (3 questtion marks) and it not supposed to be that!
(integer returned OK)

I tested my store procedure on the DB - It worked well.

I tested my Java code with small local main program that call to the DB - and it worked well. (The connection the the DB was direct with DriverManager.getConnection("jdbc:oracle:thin:@......);  )

The problem came when I used my store procedure in my big project that connect to the DB with the weblogic. 

Do you know how get the right string from the DB whan I work with the WebLogic?


Oracle code:


      PROCEDURE SearchOrder (InWoArr IN WoTab,
                         OutWoAccStat OUT WoAccStatTab) as
      outRec WoAccStatType;
      wo number(10);
      acc number(10);
      stat varchar2(2);
      begin
      OutWoAccStat := WoAccStatTab();
        for i in InWoArr.FIRST .. InWoArr.LAST loop
        OutWoAccStat.EXTEND;
          begin
           select work_order_number,account_number,' '
        into wo,acc,stat
        from table1
        where work_order_number=InWoArr(i);
        ....
        outRec := WoAccStatType(wo,acc,stat);
        OutWoAccStat(i) := outRec;
      exception
        when no_data_found then
          outRec := WoAccStatType(InWoArr(i),0,' ');
          OutWoAccStat(i) := outRec;
      end;
    end loop;
    end SearchOrder;

//Array of 200

    create or replace type poldev_dba.WoAccStatTab as VARRAY(200) of WoAccStatType

//The array type

    create or replace type poldev_dba.WoAccStatType as object (work_order_number number(10), account_number number(10), wo_status varchar2(2))

   
String returned from oracle store procedure to Java with '???'
===

My code in Java call to store procedure in the Oracle DB and return object with some fields.
When I find out the attributes from the Object - I have problem with the string. The string became '???' (3 questtion marks) and it not supposed to be that!
(integer returned OK)

I tested my store procedure on the DB - It worked well.

I tested my Java code with small local main program that call to the DB - and it worked well. (The connection the the DB was direct with DriverManager.getConnection("jdbc:oracle:thin:@......);  )

The problem came when I used my store procedure in my big project that connect to the DB with the weblogic. 

Do you know how get the right string from the DB whan I work with the WebLogic?


Oracle code:


      PROCEDURE SearchOrder (InWoArr IN WoTab,
                         OutWoAccStat OUT WoAccStatTab) as
      outRec WoAccStatType;
      wo number(10);
      acc number(10);
      stat varchar2(2);
      begin
      OutWoAccStat := WoAccStatTab();
        for i in InWoArr.FIRST .. InWoArr.LAST loop
        OutWoAccStat.EXTEND;
          begin
           select work_order_number,account_number,' '
        into wo,acc,stat
        from table1
        where work_order_number=InWoArr(i);
        ....
        outRec := WoAccStatType(wo,acc,stat);
        OutWoAccStat(i) := outRec;
      exception
        when no_data_found then
          outRec := WoAccStatType(InWoArr(i),0,' ');
          OutWoAccStat(i) := outRec;
      end;
    end loop;
    end SearchOrder;

//Array of 200

    create or replace type poldev_dba.WoAccStatTab as VARRAY(200) of WoAccStatType

//The array type

    create or replace type poldev_dba.WoAccStatType as object (work_order_number number(10), account_number number(10), wo_status varchar2(2))

   