Home » SQL & PL/SQL » SQL & PL/SQL » No more data to read from socket
No more data to read from socket [message #270242] Wed, 26 September 2007 04:46 Go to next message
atulrsingh
Messages: 55
Registered: November 2006
Location: Mumbai
Member
Hi Experts,

I am getting this error message from my frontend on running the application.

"No more data to read from socket"

After Analysing we concluded that the application is calling the package and its executed till this procedure and generates the error.

We have 2 Varray type columns in the Policy_Locations table.


Oracle Version:
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi
PL/SQL Release 10.2.0.2.0 - Production
CORE 10.2.0.2.0 Production
TNS for Solaris: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production


PROCEDURE Load_Pl_To_PlArray
IS
mMy_Count NUMBER(4);
mMy_Pl_Cur Policy_Locations_Cur%ROWTYPE;
BEGIN
Locations Array');

FOR mMy_Pl_Cur IN Policy_Locations_Cur(Auto_BillIng.cmn_Session_No) LOOP
mMy_Count := Policy_Locations_Cur%ROWCOUNT;

cmn_Pl_arr(mMy_Count) := mMy_Pl_Cur;

cmn_Pl_arr(mMy_Count).Rate_Grid_Code := cmn_Pl_arr(mMy_Count).Pl_slNo;
END LOOP;
-- auto_billing.print_log('After loading the Policy Locations array :'||mmy_count);

Auto_BillIng.Print_Log('Policy Locations array :'
||mMy_Count);
--

FOR i IN 1.. cmn_Pl_arr.COUNT LOOP
Auto_BillIng.Print_Log(cmn_Pl_arr(i).Pl_Location_Code
||'-'
||cmn_Pl_arr(i).Pl_Master_Code
||'-'
||cmn_Pl_arr(i).Pl_Rate_struct_Code);
END LOOP;
EXCEPTION
WHEN OTHERS THEN
Auto_BillIng.Print_Log('Error in loading the policy locations array due to '
||SQLERRM);

Auto_BillIng.cmn_Success_Failure := '99';

Auto_BillIng.cmn_Error_Code := 'E-ISS-0003';

Auto_BillIng.cmn_Error_Mesg := 'policy_locations'
||','
||'load_pl_to_plarray'
||','
||SQLERRM;

Auto_BillIng.Ins_Error_Log(Auto_BillIng.cmn_Error_Code,Auto_BillIng.cmn_Error_Mesg,
'load_pl_to_plarray', -- additional referance
'auto_billing_objects' -- source
);
END Load_Pl_To_PlArray;


Table structure:

DESC POLICY_LOCATIONS :

PL_SESSION_NO NUMBER(11,0)
PL_LOCATION_CODE VARCHAR2(8 BYTE)
PL_POLICY_NO VARCHAR2(15 BYTE)
PL_POLICY_RENEW_NO VARCHAR2(2 BYTE)
PL_SLNO NUMBER(3,0)
PL_MASTER_CODE VARCHAR2(8 BYTE)
PL_RATE_STRUCT_CODE NUMBER(3,0)
PL_BEGIN_DATE DATE
PL_END_DATE DATE
PL_PRIMARY_LOCATION VARCHAR2(1 BYTE)
PL_FLOOR_PLAN VARCHAR2(1 BYTE)
PL_LIABILITY_TERRITORY VARCHAR2(3 BYTE)
PL_RATING_DATE DATE
PL_LATITUDE NUMBER(8,4)
PL_LONGITUDE NUMBER(8,4)
PL_OCCUPANCY VARCHAR2(3 BYTE)
PL_CURR_OWNERSHIP_NO_OF_YEARS NUMBER(3,0)
PL_BLEND_GROUP_CODE VARCHAR2(8 BYTE)
PL_WT_GROUP_CODE VARCHAR2(8 BYTE)
PL_MATCHED_GROUP_CODE VARCHAR2(8 BYTE)
PL_OWNERSHIP_GROUP_CODE VARCHAR2(8 BYTE)
PL_DEL_FLAG VARCHAR2(1 BYTE)
PL_EDR_SESSION_NO NUMBER(11,0)
PL_EDR_EFF_DATE DATE
PL_EDR_CODE VARCHAR2(7 BYTE)
PL_CREATED_ON DATE
PL_CREATED_BY VARCHAR2(15 BYTE)
PL_MODIFIED_ON DATE
PL_MODIFIED_BY VARCHAR2(15 BYTE)
PL_PRIOR_LOC_CODE VARCHAR2(8 BYTE)
PL_FALSE_PRETENSE_LIMIT VARCHAR2(20 BYTE)
PL_LOSS_REPORTING_FROM DATE
PL_LOSS_REPORTING_TO DATE
PL_MATCHED_TO VARCHAR2(8 BYTE)
PL_FLOOD_EXCLUDED VARCHAR2(3 BYTE)
PL_FLOOD_DEDUCTIBLE VARCHAR2(20 BYTE)
PL_RATE_GRID_CODE NUMBER(3,0)
PL_GROUP_CODE VARCHAR2(10 BYTE)
PL_LOCATION_SLNO NUMBER(20,0)
PL_BUILDING_SLNO NUMBER(20,0)
PL_MASTER_LOC_CODE VARCHAR2(8 BYTE)
PL_RATE_YN VARCHAR2(1 BYTE)
PL_PROTECTION_CLASS VARCHAR2(2 BYTE)
PL_YEAR_BUILT NUMBER(4,0)
PL_RENOVATION_YEAR NUMBER(4,0)
PL_CONSTRUCTION_TYPE VARCHAR2(3 BYTE)
PL_TOTAL_SQUARE_FOOTAGE NUMBER(10,2)
PL_SPRINKLRED_PERC NUMBER(5,2)
PL_NO_OF_STORIES NUMBER(4,0)
PL_REMARKS VARCHAR2(4000 BYTE)
PL_NO_OF_YEARS_BUSINESS NUMBER(4,1)
PL_SAFETY_FEATURES SAFETY_FEATURES_VARRAY
PL_FLOOD_ZONE VARCHAR2(5 BYTE)
PL_SURGE_ZONE VARCHAR2(5 BYTE)
PL_EARTHQUAKE_ZONE VARCHAR2(5 BYTE)
PL_HAIL_ZONE VARCHAR2(5 BYTE)
PL_HAIL_NET_YN VARCHAR2(5 BYTE)
PL_HAIL_NET_EXPOSURE NUMBER(12,2)
PL_DISTANCE_TO_COAST NUMBER(5,2)
PL_PARKING_GARAGES NUMBER(12,2)
PL_BAC VARCHAR2(15 BYTE)
PL_GROUP_DESC VARCHAR2(10 BYTE)
PL_ADDITIONAL_INFO ADDITIONAL_INFO_VARRAY


Varray Structure DETAILS
1. Additional info Varray

Object:

create or replace TYPE additional_info_type AS OBJECT
(
Add_field_name VARCHAR2(5),
Add_field_value VARCHAR2(35)
)


Type:

create or replace TYPE additional_info_varray AS VARRAY(10) OF additional_info_type;


2. Safety Features Varray

Object:

create or replace TYPE "SAFETY_FEATURES_OBJ" AS OBJECT
(
SAFETY_FEATURE VARCHAR2(3)
)


Type :

create or replace TYPE "SAFETY_FEATURES_VARRAY"

----------------------------


Please Suggest some solutions.

Thnx
Atul




Re: No more data to read from socket [message #270246 is a reply to message #270242] Wed, 26 September 2007 04:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No formatting, no answer.

Please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Please always post your Oracle version (4 decimals).

Regards
Michel
Re: No more data to read from socket [message #270249 is a reply to message #270242] Wed, 26 September 2007 05:33 Go to previous messageGo to next message
atulrsingh
Messages: 55
Registered: November 2006
Location: Mumbai
Member

Please Check the code part is formatted now...

I am getting this error message from my frontend on running the application.

"No more data to read from socket"

After Analysing we concluded that the application is calling the package and its executed till this procedure and generates the error.

We have 2 Varray type columns in the Policy_Locations table.


Oracle Version:
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi
PL/SQL Release 10.2.0.2.0 - Production
CORE 10.2.0.2.0 Production
TNS for Solaris: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production


PROCEDURE Load_Pl_To_PlArray
IS
mMy_Count NUMBER(4);
mMy_Pl_Cur Policy_Locations_Cur%ROWTYPE;
BEGIN
FOR mMy_Pl_Cur IN Policy_Locations_Cur(Auto_BillIng.cmn_Session_No) LOOP
mMy_Count := Policy_Locations_Cur%ROWCOUNT;

cmn_Pl_arr(mMy_Count) := mMy_Pl_Cur;

cmn_Pl_arr(mMy_Count).Rate_Grid_Code := cmn_Pl_arr(mMy_Count).Pl_slNo;
END LOOP;
-- auto_billing.print_log('After loading the Policy Locations array :'||mmy_count);

Auto_BillIng.Print_Log('Policy Locations array :'
||mMy_Count);
--

FOR i IN 1.. cmn_Pl_arr.COUNT LOOP
Auto_BillIng.Print_Log(cmn_Pl_arr(i).Pl_Location_Code
||'-'
||cmn_Pl_arr(i).Pl_Master_Code
||'-'
||cmn_Pl_arr(i).Pl_Rate_struct_Code);
END LOOP;
EXCEPTION
WHEN OTHERS THEN
Auto_BillIng.Print_Log('Error in loading the policy locations array due to '
||SQLERRM);

Auto_BillIng.cmn_Success_Failure := '99';

Auto_BillIng.cmn_Error_Code := 'E-ISS-0003';

Auto_BillIng.cmn_Error_Mesg := 'policy_locations'
||','
||'load_pl_to_plarray'
||','
||SQLERRM;

Auto_BillIng.Ins_Error_Log(Auto_BillIng.cmn_Error_Code,Auto_BillIng.cmn_Error_Mesg,
'load_pl_to_plarray', -- additional referance
'auto_billing_objects' -- source
);
END Load_Pl_To_PlArray;


Table structure:

DESC POLICY_LOCATIONS :

PL_SESSION_NO NUMBER(11,0)
PL_LOCATION_CODE VARCHAR2(8 BYTE)
PL_POLICY_NO VARCHAR2(15 BYTE)
PL_POLICY_RENEW_NO VARCHAR2(2 BYTE)
PL_SLNO NUMBER(3,0)
PL_MASTER_CODE VARCHAR2(8 BYTE)
PL_RATE_STRUCT_CODE NUMBER(3,0)
PL_BEGIN_DATE DATE
PL_END_DATE DATE
PL_PRIMARY_LOCATION VARCHAR2(1 BYTE)
PL_FLOOR_PLAN VARCHAR2(1 BYTE)
PL_LIABILITY_TERRITORY VARCHAR2(3 BYTE)
PL_RATING_DATE DATE
PL_LATITUDE NUMBER(8,4)
PL_LONGITUDE NUMBER(8,4)
PL_OCCUPANCY VARCHAR2(3 BYTE)
PL_CURR_OWNERSHIP_NO_OF_YEARS NUMBER(3,0)
PL_BLEND_GROUP_CODE VARCHAR2(8 BYTE)
PL_WT_GROUP_CODE VARCHAR2(8 BYTE)
PL_MATCHED_GROUP_CODE VARCHAR2(8 BYTE)
PL_OWNERSHIP_GROUP_CODE VARCHAR2(8 BYTE)
PL_DEL_FLAG VARCHAR2(1 BYTE)
PL_EDR_SESSION_NO NUMBER(11,0)
PL_EDR_EFF_DATE DATE
PL_EDR_CODE VARCHAR2(7 BYTE)
PL_CREATED_ON DATE
PL_CREATED_BY VARCHAR2(15 BYTE)
PL_MODIFIED_ON DATE
PL_MODIFIED_BY VARCHAR2(15 BYTE)
PL_PRIOR_LOC_CODE VARCHAR2(8 BYTE)
PL_FALSE_PRETENSE_LIMIT VARCHAR2(20 BYTE)
PL_LOSS_REPORTING_FROM DATE
PL_LOSS_REPORTING_TO DATE
PL_MATCHED_TO VARCHAR2(8 BYTE)
PL_FLOOD_EXCLUDED VARCHAR2(3 BYTE)
PL_FLOOD_DEDUCTIBLE VARCHAR2(20 BYTE)
PL_RATE_GRID_CODE NUMBER(3,0)
PL_GROUP_CODE VARCHAR2(10 BYTE)
PL_LOCATION_SLNO NUMBER(20,0)
PL_BUILDING_SLNO NUMBER(20,0)
PL_MASTER_LOC_CODE VARCHAR2(8 BYTE)
PL_RATE_YN VARCHAR2(1 BYTE)
PL_PROTECTION_CLASS VARCHAR2(2 BYTE)
PL_YEAR_BUILT NUMBER(4,0)
PL_RENOVATION_YEAR NUMBER(4,0)
PL_CONSTRUCTION_TYPE VARCHAR2(3 BYTE)
PL_TOTAL_SQUARE_FOOTAGE NUMBER(10,2)
PL_SPRINKLRED_PERC NUMBER(5,2)
PL_NO_OF_STORIES NUMBER(4,0)
PL_REMARKS VARCHAR2(4000 BYTE)
PL_NO_OF_YEARS_BUSINESS NUMBER(4,1)
PL_SAFETY_FEATURES SAFETY_FEATURES_VARRAY
PL_FLOOD_ZONE VARCHAR2(5 BYTE)
PL_SURGE_ZONE VARCHAR2(5 BYTE)
PL_EARTHQUAKE_ZONE VARCHAR2(5 BYTE)
PL_HAIL_ZONE VARCHAR2(5 BYTE)
PL_HAIL_NET_YN VARCHAR2(5 BYTE)
PL_HAIL_NET_EXPOSURE NUMBER(12,2)
PL_DISTANCE_TO_COAST NUMBER(5,2)
PL_PARKING_GARAGES NUMBER(12,2)
PL_BAC VARCHAR2(15 BYTE)
PL_GROUP_DESC VARCHAR2(10 BYTE)
PL_ADDITIONAL_INFO ADDITIONAL_INFO_VARRAY


Varray Structure DETAILS
1. Additional info Varray

Object:

create or replace TYPE additional_info_type AS OBJECT
(
Add_field_name VARCHAR2(5),
Add_field_value VARCHAR2(35)
)


Type:

create or replace TYPE additional_info_varray AS VARRAY(10) OF additional_info_type;


2. Safety Features Varray

Object:

create or replace TYPE "SAFETY_FEATURES_OBJ" AS OBJECT
(
SAFETY_FEATURE VARCHAR2(3)
)


Type :

create or replace TYPE "SAFETY_FEATURES_VARRAY"

----------------------------


Please Suggest some solutions.

Thnx
Atul
Re: No more data to read from socket [message #270264 is a reply to message #270249] Wed, 26 September 2007 06:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Please Check the code part is formatted now...

No it is not.
Read the guide, try to understand it and apply it.

Regards
Michel

[Updated on: Wed, 26 September 2007 06:18]

Report message to a moderator

Re: No more data to read from socket [message #270271 is a reply to message #270242] Wed, 26 September 2007 06:28 Go to previous messageGo to next message
atulrsingh
Messages: 55
Registered: November 2006
Location: Mumbai
Member
Please Check it Now... Looks better than Before

PROCEDURE Load_Pl_To_PlArray
IS
mMy_Count NUMBER(4);
mMy_Pl_Cur Policy_Locations_Cur%ROWTYPE;
BEGIN
FOR mMy_Pl_Cur IN Policy_Locations_Cur(Auto_BillIng.cmn_Session_No) LOOP
mMy_Count := Policy_Locations_Cur%ROWCOUNT;

cmn_Pl_arr(mMy_Count) := mMy_Pl_Cur;

cmn_Pl_arr(mMy_Count).Rate_Grid_Code := cmn_Pl_arr(mMy_Count).Pl_slNo;
END LOOP;

FOR i IN 1.. cmn_Pl_arr.COUNT LOOP
END LOOP;

EXCEPTION
WHEN OTHERS THEN
Auto_BillIng.Print_Log('Error in loading the policy locations array due to '
||SQLERRM);

Auto_BillIng.cmn_Success_Failure := '99';

Auto_BillIng.cmn_Error_Code := 'E-ISS-0003';

Auto_BillIng.cmn_Error_Mesg := 'policy_locations'
||','
||'load_pl_to_plarray'
||','
||SQLERRM;

Auto_BillIng.Ins_Error_Log(Auto_BillIng.cmn_Error_Code,Auto_BillIng.cmn_Error_Mesg,
'load_pl_to_plarray', -- additional referance
'auto_billing_objects' -- source
);
END Load_Pl_To_PlArray;

[Updated on: Wed, 26 September 2007 06:35]

Report message to a moderator

Re: No more data to read from socket [message #270290 is a reply to message #270271] Wed, 26 September 2007 07:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, it is not better. Use "Preview Message" button BEFORE clicking on "Submit Reply".

Regards
Michel
Re: No more data to read from socket [message #270297 is a reply to message #270290] Wed, 26 September 2007 07:49 Go to previous message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Gee! This code is not formatted:

SELECT something
FROM this_table
WHERE some_condition
AND another condition
ORDER BY column;

This code is formatted:
SELECT something
  FROM this_table
  WHERE some_condition
    AND another condition
ORDER BY column;

Read the OraFAQ Forum Guide and learn how to properly ask a question (and format it using the [code] tags).
Previous Topic: How identity gets maintained?
Next Topic: How to loop through Unix files in a PL/SQL Package
Goto Forum:
  


Current Time: Wed Dec 07 05:18:19 CST 2016

Total time taken to generate the page: 0.12018 seconds