Re: Data block wizard with OCA
Date: Fri, 15 Jan 1999 21:36:48 +0100
Message-ID: <77o946$jo$1_at_trex.antw.online.be>
[Quoted] Did you specify the all_tables all_views user_tables and user_views on your server. This is what developer needs to make the wizard work.
Try to make this views on your server - you can create a new view or a new table containing the necessary data.
Eg: for the USER_TABLES VIEW
the description is
Name Null? Type ------------------------------- -------- ---- 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) NESTED VARCHAR2(3) BUFFER_POOL VARCHAR2(7)
Jonathan Gauthier heeft geschreven in bericht ...
>I'm trying to create a data block with the data block wizard in form
builder
>with an odbc datasource to a mssql(sql server) database but I keep getting
>the error message ORA-01012: not logged on when I input the name of the
>table and click on refresh to get the columns names. If I try to click on
>browse instead I get nothing at all.
>
>I know my connection works because I can go in the mssql database with
>oracle sqlplus and do a select * from all_tables;
>
>Here is my configuration
>
>Forms 5.0.5.4.0
>MSSQL 6.5
>ODBC Sql Server driver from Microsoft
>- I could not try with the odbc driver from intersolv because I'm using a
>trial version of forms and the driver is not included
>
>Please email me directly, I don't always read newsgroups
>
>
>
Received on Fri Jan 15 1999 - 21:36:48 CET