Version Details
SQL> select *
2 from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE 11.1.0.7.0 Production
TNS for Solaris: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production
Hi Everyone,
I'm getting disconnected from oracle session while using parallel hint in my ref cursor query.
Below is the insert which inturn calls a pipelined function
SQL> Select cp_rel_id,
2 cw_geid,
3 1 p_sys_id,
4 rel_mstr_auth_flag,
5 modified_yn,
6 first_name,
7 last_name,
8 session_id
9 from table(fn_visibility_pieplined(
10 cursor(
11 SELECT /*+ parallel(t1) */t1.*
12 FROM v_crcw t1
13 WHERE cw_sys_id = 'LACW'
14 AND EXISTS (
15 SELECT geid
16 FROM cp_org_structure
17 WHERE system_id = 1
18 AND auth_flag='Y'
19 AND oc_status='O'
20 AND cpuser_yn='Y'
21 )
22 ),
23 1,
24 'LACW',
25 'I',
26 'USA',
27 NULL
28 )
29 )
30 ;
Select cp_rel_id,
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
But when I remove parallel hint from my select ,its working fine.
My pipelined function spec looks as below
Create or replace Function fn_visibility_pieplined
(
p_ref_cursor in sys_refcursor,
psys_id in number,
pcw_sys_id in varchar2,
prfrsh_type in varchar2,
pregionind in varchar2,
p_merge_flag in varchar2
)
return t_acct_team_tab pipelined
parallel_enable( partition p_ref_cursor by any )
Is
Please help me.