This discussion is archived
1 2 Previous Next 21 Replies Latest reply: Feb 28, 2012 1:38 PM by 832009 Go to original post RSS
  • 15. Re: Oracle SQLException: No more data to read from socket
    rp0428 Guru
    Currently Being Moderated
    >
    via out parameter
    >
    Well now you are starting to provide some info.

    Can you provide the Stored procedure definition including the types of the OUT and other parameters? Is the OUT parameter an Array type?

    Also need the query being used to see how the parameters are being supplied by the Java code and how the result set is being read.

    A problem when the result set is large can be related the the JDBC buffer size being allocated. The buffer size will be allocated based on the
    max possible row size for the column types being retrieved times the number of rows expected (fetch size).
  • 16. Re: Oracle SQLException: No more data to read from socket
    832009 Newbie
    Currently Being Moderated
    HI RP..!!!

    Yes may b u r right... aaray is there... I have the procedure.. is there any way out to deal with that JDBC buffer u said..

    PROCEDURE P_sar_amb
    (
    p_StdInOut_typ IN OUT StdInOut_t,
    p_StdIn_typ IN StdIn_t,
    p_MainIn_typ IN SDM_BCT_t,
    p_MainOut_typ OUT SDM_MCT_t
    )


    in this all types & functions are used to fetch the result.
  • 17. Re: Oracle SQLException: No more data to read from socket
    832009 Newbie
    Currently Being Moderated
    Also should I go through Alert log or trace files..?
  • 18. Re: Oracle SQLException: No more data to read from socket
    rp0428 Guru
    Currently Being Moderated
    Still waiting for
    >
    Also need the query being used to see how the parameters are being supplied by the Java code and how the result set is being read.
    >
    And the definition of the type: SDM_MCT_t

    Can you explain what you mean by
    >
    in this all types & functions are used to fetch the result.
  • 19. Re: Oracle SQLException: No more data to read from socket
    832009 Newbie
    Currently Being Moderated
    Hi RP/ All .. This is the Java Code from which the procedure is being called.

    public SDM_ModulSichtCT_t readModulsichtNeu( SDM_BaumFilterCT_t p_Filter ) throws DatabaseException
    {
    return (SDM_ModulSichtCT_t) callProcedure ( "*P_sar_amb*", "ReadModulsichtNeu", p_Filter,
    new SDM_ModulSichtCT_t() );
    }

    =======================================The definition of the type: SDM_MCT_t=========================

    create or replace TYPE "SDM_MCT_t" AS OBJECT               
    (
    ProduktlinieCT SDM_ProduktlinieCT_t
    ,MengengeruestCT SDM_MengengeruestCT_t
    ,ProjektCT SDM_ProjektCT_t
    ,IsModulsichtNeu VARCHAR2(1)
    ,CONSTRUCTOR FUNCTION SDM_MCT_t RETURN SELF AS RESULT
    )
    NOT FINAL

    =============================================The Entire P_sar_amb procedure

    PROCEDURE P_sar_amb
    (
    p_StdInOut_typ IN OUT StdInOut_t,
    p_StdIn_typ IN StdIn_t,
    p_MainIn_typ IN SDM_BCT_t,
    p_MainOut_typ OUT SDM_MCT_t
    ) IS
    v_StdLocal_rec PsyStdImplTypes_p.StdLocal_rect := PsyStdImpl_p.GetStdLocalNormalProcedure('P_sar_amb');
    v_StdIn_typ PsyStdDeclTypes_p.StdIn_typt := PsyStdImpl_p.GetStdInInternalProcedure;
    BEGIN
              LOG_PSYTEKKAPP_P.startproc($$PLSQL_UNIT||'.P_sar_amb',p_stdin_typ,v_leveloneid); --Added for TPA 84392


    v_StdLocal_rec.PackageName := c_PackageName;
    PsyStdImpl_p.InitProcedure(p_StdInOut_typ, p_StdIn_typ, v_StdLocal_rec);

    IF SDM_Constants_p.c_Wartung = TRUE THEN
    SDM_Wartung_p.CreateWartungInfo(v_StdLocal_rec, p_StdIn_typ, p_MainIn_typ);
    END IF;
    -- Procedure begin
    P_sar_ambx(
    p_StdInOut_typ, v_StdIn_typ,
    p_MainIn_typ,
    FALSE, -- Alte Modulsicht lesen
    p_MainOut_typ
    );
    p_MainOut_typ.IsModulSichtNeu := PsyConstants_p.c_boolTrue;
    -- Procedure end
    PsyStdImpl_p.FinishProcedure(p_StdInOut_typ, p_StdIn_typ, v_StdLocal_rec);



              LOG_PSYTEKKAPP_P.endproc($$PLSQL_UNIT||'.P_sar_amb',p_stdin_typ,v_leveloneid);
    EXCEPTION
    WHEN OTHERS THEN
    PsyStdImpl_p.ProcessException(p_StdInOut_typ, p_StdIn_typ, v_StdLocal_rec, SQLCODE);
    IF (PsyStdImpl_p.CanThrowException(p_StdIn_typ) = TRUE)
    THEN
    RAISE;
    END IF;
    END P_sar_amb;
  • 20. Re: Oracle SQLException: No more data to read from socket
    rp0428 Guru
    Currently Being Moderated
    I know you are trying to help buti it is the Java code part that is likely to be the problem
    >
    Still waiting for

    Also need the query being used to see how the parameters are being supplied by the Java code and how the result set is being read.
    >
    The code in this procedure call
    >
    return (SDM_ModulSichtCT_t) callProcedure ( "P_sar_amb", "ReadModulsichtNeu", p_Filter,
    new SDM_ModulSichtCT_t() );
    >
    that creates the JDBC parameters for the call to 'p_sar_amp'.
    The most likely cause of the exceptin is JDBC making multiple calls to the DB.
    Is this code running in Weblogic? Is it multi-threaded? Is the DB using dedicated server or shared server?
    See if anything at this post looks similar to what you are doing in the Java code
    http://www.orafaq.com/forum/t/47457/0/
  • 21. Re: Oracle SQLException: No more data to read from socket
    832009 Newbie
    Currently Being Moderated
    Hi all..

    Sorry for late reply.. But atlast the issue solved. we updated the oracle database server by latest patch & the issue resolved.!! Thanks all for help & clues..!!

    Regrads
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points