"ObjectTypeName must be specified" when creating new query

PatConnelly · Post by **PatConnelly** » Tue 29 Aug 2006 17:18

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

Alexey · Post by **Alexey** » Wed 30 Aug 2006 09:17

Please provide me with your table definition and SQL statement for the TableAdapter.

PatConnelly · Post by **PatConnelly** » Wed 30 Aug 2006 12:53

Alexey wrote:Please provide me with your table definition and SQL statement for the TableAdapter.

It happens with everything I have tried. I tried with the following, and got the same results:

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

Thanks,

Patrick

Alexey · Post by **Alexey** » Thu 31 Aug 2006 07:06

We reproduced the problem and now fixing it. Look forward to the next build.

Alexey · Post by **Alexey** » Thu 21 Sep 2006 09:59

We have fixed this problem. New build is coming out soon.