Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Oracle: Dataset with multiple tables - problem!
3 views
Skip to first unread message
Lasa
Aug 17, 2007, 7:06:26 AM8/17/07
to
Hi,
I need to populate a dataset with number of tables for Oracle 10g
database.
There I need to use a data adapter and need to pass a sqlString with
multiple table select statements at once.
(eg: sqlString = "select * from table1 ; select * from table2 ; select
* from table3" ;)
this sqlString is working fine with SQL Server 2000 and DB2 data
bases. but unfortunately not with Oracle database.
I need to populate a dataset with number of tables for Oracle 10g
database.
There I need to use a data adapter and need to pass a sqlString with
multiple table select statements at once.
(eg: sqlString = "select * from table1 ; select * from table2 ; select
* from table3" ;)
this sqlString is working fine with SQL Server 2000 and DB2 data
bases. but unfortunately not with Oracle database.
Can you please let me know a way to overcome this issue?
Rgds,
Lasa
Lasa
Aug 17, 2007, 7:07:06 AM8/17/07
to
Hi,
I need to populate a dataset with number of tables for Oracle 10g
database.
There I need to use a data adapter and need to pass a sqlString with
multiple table select statements at once.
(eg: sqlString = "select * from table1 ; select * from table2 ; select
* from table3" ;)
this sqlString is working fine with SQL Server 2000 and DB2 data
bases. but unfortunately not with Oracle database.
(error showing at the ; character !)I need to populate a dataset with number of tables for Oracle 10g
database.
There I need to use a data adapter and need to pass a sqlString with
multiple table select statements at once.
(eg: sqlString = "select * from table1 ; select * from table2 ; select
* from table3" ;)
this sqlString is working fine with SQL Server 2000 and DB2 data
bases. but unfortunately not with Oracle database.
0 new messages