|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
end-of-file on communication channel
I use oracle Release 9.0.1.0.1
and i have a view like this: create or replace view test as ( select requests.rqs_no , requests.address , requests.area_cd , unwanted_off.reason, unwanted_off.status, case when unwanted_off.rqs_no is null then 0 when (status in(5,6) ) then 1 when (status =4 and ref_rqs_no in (select rqs_no from unwanted_off where status=6 )) then 1 when (status =3 and ref_rqs_no in (select rqs_no from wanted_off)) then 1 else 0 end chk FROM groups, req_rsn_opr, reasons, requests, unwanted_off where requests.off_type=1 and requests.grp_code=groups.groups_code(+) and requests.main_rsn_opr=req_rsn_opr.rsn_opr_code(+) and requests.rqs_no=unwanted_off.rqs_no(+) and unwanted_off.main_reason=reasons.reason_code(+) ); now : sql> select rqs_no from test where area_cd=1 and chk=:Parameter; it works fine but: sql> select rqs_no,chk from test where area_cd=1 and chk= arameter ; it show me this error: ERROR at line 1: ORA-03113: end-of-file on communication channel i have to send a parameter for chk because i use formbuilder. i want to know what is wrong with this view. best regards. |
|
#2
|
|||
|
|||
|
This has nothing to do with your SQL.
There is some type of TWO_TASK failure (SQLNet). Get your DBA to look for a trace |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > end-of-file on communication channel |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|