I have a dataset with several datatables in it.
It works fine when there are no parameters in the query. If I add a TableAdapter with a query that includes parameters, I get message:
ObjectTypeName must be specified
when I click the "Finish" button on the wizard. At this point, the datatable is created, but contains no columns. To get a table created, I first must create the table with no parameters. That works fine. I then go back into the query and add the parameters. I will still get the error when I click "Finish", but then I go into the parameters on the Select statement, and change the DBType from "Object" to Int32 (or whatever) and the ProviderType changes from null to a valid type.
If I go back into the query to make a change, it happens all over again and I must go through all the parameters resetting the types.
I am using Studio 2005 and OraDirect.Net Pro, version 3.50.12.0. Using a direct connection to Oracle.
Thanks
Patrick Connelly
"ObjectTypeName must be specified" when creating new query
-
- Posts: 18
- Joined: Fri 17 Jun 2005 14:15
-
- Posts: 18
- Joined: Fri 17 Jun 2005 14:15
It happens with everything I have tried. I tried with the following, and got the same results:Alexey wrote:Please provide me with your table definition and SQL statement for the TableAdapter.
Code: Select all
select table_name from all_tables where blocks > :blocks
OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
TABLESPACE_NAME VARCHAR2(30)
CLUSTER_NAME VARCHAR2(30)
IOT_NAME VARCHAR2(30)
PCT_FREE NUMBER
PCT_USED NUMBER
INI_TRANS NUMBER
MAX_TRANS NUMBER
INITIAL_EXTENT NUMBER
NEXT_EXTENT NUMBER
MIN_EXTENTS NUMBER
MAX_EXTENTS NUMBER
PCT_INCREASE NUMBER
FREELISTS NUMBER
FREELIST_GROUPS NUMBER
LOGGING VARCHAR2(3)
BACKED_UP VARCHAR2(1)
NUM_ROWS NUMBER
BLOCKS NUMBER
EMPTY_BLOCKS NUMBER
AVG_SPACE NUMBER
CHAIN_CNT NUMBER
AVG_ROW_LEN NUMBER
AVG_SPACE_FREELIST_BLOCKS NUMBER
NUM_FREELIST_BLOCKS NUMBER
DEGREE VARCHAR2(10)
INSTANCES VARCHAR2(10)
CACHE VARCHAR2(5)
TABLE_LOCK VARCHAR2(8)
SAMPLE_SIZE NUMBER
LAST_ANALYZED DATE
PARTITIONED VARCHAR2(3)
IOT_TYPE VARCHAR2(12)
TEMPORARY VARCHAR2(1)
SECONDARY VARCHAR2(1)
NESTED VARCHAR2(3)
BUFFER_POOL VARCHAR2(7)
ROW_MOVEMENT VARCHAR2(8)
GLOBAL_STATS VARCHAR2(3)
USER_STATS VARCHAR2(3)
DURATION VARCHAR2(15)
SKIP_CORRUPT VARCHAR2(8)
MONITORING VARCHAR2(3)
CLUSTER_OWNER VARCHAR2(30)
DEPENDENCIES VARCHAR2(8)
COMPRESSION VARCHAR2(8)
We are running Oracle version:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
PL/SQL Release 9.2.0.6.0 - Production
CORE 9.2.0.6.0 Production
TNS for 32-bit Windows: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production
Patrick