"Select * Form testtable" froze Developer - 03/21/07 05:59 PM
Situation:
1-->
CREATE OR REPLACE TYPE DEV_MT300_15D_T1 AS OBJECT (
p17a Varchar2(1),
p32b_1 Varchar2(3),
p32b_2 Varchar2(15),
p53V Varchar2(1),
p53_PID Varchar2(40),
p53_1 Varchar2(40),
p53_2 Varchar2(40),
p53_3 Varchar2(40),
p53_4 Varchar2(40),
p53_5 Varchar2(40),
p56V Varchar2(1),
p56_PID Varchar2(40),
p56_1 Varchar2(40),
p56_2 Varchar2(40),
p56_3 Varchar2(40),
p56_4 Varchar2(40),
p56_5 Varchar2(40),
p57V Varchar2(1),
p57_PID Varchar2(40),
p57_1 Varchar2(40),
p57_2 Varchar2(40),
p57_3 Varchar2(40),
p57_4 Varchar2(40),
p57_5 Varchar2(40),
p58V Varchar2(1),
p58_PID Varchar2(40),
p58_1 Varchar2(40),
p58_2 Varchar2(40),
p58_3 Varchar2(40),
p58_4 Varchar2(40),
p58_5 Varchar2(40)
);
2-->
CREATE OR REPLACE TYPE DEV_MT300_15D_T2 AS VARRAY(10) OF DEV_MT300_15D_T1;
3-->
create table TESTTABLE
(
A_P20 VARCHAR2(16) not null,
...
D_P17ATOP58 DEV_MT300_15D_T2,
...)
4-->
Grant all to second user and make public synonym
5--> Connect as second user
6--> select * Form TESTTABLE
RESULT:
ERROR screen saying:
Access violation at adress 606B90F0 in module 'OraClient9.Dll'. Read of address 00000000
7--> After OK only "END TASK" helps
Anyone?
p.s. When first user does the same "select" there's no error!
1-->
CREATE OR REPLACE TYPE DEV_MT300_15D_T1 AS OBJECT (
p17a Varchar2(1),
p32b_1 Varchar2(3),
p32b_2 Varchar2(15),
p53V Varchar2(1),
p53_PID Varchar2(40),
p53_1 Varchar2(40),
p53_2 Varchar2(40),
p53_3 Varchar2(40),
p53_4 Varchar2(40),
p53_5 Varchar2(40),
p56V Varchar2(1),
p56_PID Varchar2(40),
p56_1 Varchar2(40),
p56_2 Varchar2(40),
p56_3 Varchar2(40),
p56_4 Varchar2(40),
p56_5 Varchar2(40),
p57V Varchar2(1),
p57_PID Varchar2(40),
p57_1 Varchar2(40),
p57_2 Varchar2(40),
p57_3 Varchar2(40),
p57_4 Varchar2(40),
p57_5 Varchar2(40),
p58V Varchar2(1),
p58_PID Varchar2(40),
p58_1 Varchar2(40),
p58_2 Varchar2(40),
p58_3 Varchar2(40),
p58_4 Varchar2(40),
p58_5 Varchar2(40)
);
2-->
CREATE OR REPLACE TYPE DEV_MT300_15D_T2 AS VARRAY(10) OF DEV_MT300_15D_T1;
3-->
create table TESTTABLE
(
A_P20 VARCHAR2(16) not null,
...
D_P17ATOP58 DEV_MT300_15D_T2,
...)
4-->
Grant all to second user and make public synonym
5--> Connect as second user
6--> select * Form TESTTABLE
RESULT:
ERROR screen saying:
Access violation at adress 606B90F0 in module 'OraClient9.Dll'. Read of address 00000000
7--> After OK only "END TASK" helps
Anyone?
p.s. When first user does the same "select" there's no error!