Error about CLOB Column in the View

From: <goldenge_at_chinasystems-cn.com>
Date: Sat, 10 Oct 1998 06:16:09 GMT
Message-ID: <6vmu39$4sq$1@nnrp1.dejanews.com>

Dear all,
 Help, please. Can anybody tell me what's about the following thing? Assumed that there are two tables and one view:

   tab1(t1 char(4), t2 clob), tab2(t3 char(4), t4 clob),    view1(t1,t2,t3,t4). View1 created by tab1&tab2 as following: create view view1 as select t1,t2,t3,t4 from tab1, tab2 where t1 = t3. I use the Visual FoxPro V5.0 through the ODBC(Oracle v8.0.4) to connect the database server(Oracle V8.0.4) and query the data in the table and view.

1.?sqlexecute(ConnectHandle,'select * from tab1','Cursor_tab1')
2.?sqlexecute(ConnectHandle,'select * from tab2','Cursor_tab2')
3.?sqlexecute(ConnectHandle,'select * from view1','Cursor_view1')

In step 1 and step 2, I can query all data in the two tables. But in the step 3 , I can not query the data of column 't4',the values markes as this '***********......'.
Do we can not create view that have more than one CLOB column from different tables?

Thanks in Advance.
Golden Ge
E-mail:goldenge_at_chinasystems-cn.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Oct 10 1998 - 01:16:09 CDT