Actually I've written some codes with server_ (connect,execute..) like as
below
include "mapbasic.def"
dim hdbc,hstmt as integer
declare sub main
sub main
hdbc=Server_Connect("ORAINET", "SRVR=testmap;USR=mapinfo;PWD=mapinfo")
hstmt = Server_Execute(hdbc, "Select * from street_table where mi_prinx=20")
Server hstmt Fetch Into "Mytest"
Server hstmt Close
end sub
but in the "server hstmt fetch" line I got unsupported data type: geoloc
error because of tring to get object column (sdo_geometry data type) which
is not supported by mapinfo.
-----Original Message-----
From: Markus Lindner [mailto:[EMAIL PROTECTED]
Sent: Monday, July 11, 2005 2:55 PM
To: Enis Büyükgüner
Cc: [email protected]
Subject: Re: MI-L Mapinfo sql select - Oracle 10g
Hello,
that is the way how Mapinfo works with Oracle.
The SQL Query downloads all data and then executes the query locally.
If you want the SQL to be executed in Oracle you will have to
do a little bit of programming with the Server_....(Connect,Execute,etc)
Functions, or use a MapBasic Tool (I never used it, so i only know that
there is a tool
which executes SQL remote in the database).
For me i rather work with SQL*Plus and Toad for simple queries, or i use
views and other Oracle
technologies inside of Oracle.
regards
Markus
Enis Büyükgüner schrieb:
>Hi all
>
>
>
>I've uploaded the street data (polyline) into Oracle 10g by using easyload
>8.0 and opened them from Mapinfo 8.0 as a live table without cache. Every
>thing looks like fine except sql select in mapinfo. The total row count of
>my table is 227000. My problem is for instance when execute a very simple
>query like "select * from street_table where mi_prinx =20" in mapinfo it
>takes too much time to open the result browser window although mi_prinx
>column is indexed. When I execute the same query in pl/sql it doesn't take
>even a second. By the way I noticed that when I push the escape button
while
>the query is running in mapinfo, the process is interrupted and I saw that
>the query was completed successfully. Thereupon I've traced the query in
>oracle and saw that after my query was executed, mapinfo tries to get the
>whole data without giving any filter. That's why the query execution takes
>the same time as when I open whole street data in top zoom level. I'm
>waiting for your help to solve my problem..
>
>
>
>Regards
>
>
>
>
>
>
>
>
>
>
>
>
--
CISS TDI GmbH <http://www.ciss.de/>
Markus Lindner CISS TDI GmbH
Tel. +49 2642 97 80 0 Barbarossastraße 36
Fax. +49 2642 97 80 10 53489 Sinzig, Germany
mailto:[EMAIL PROTECTED] http://www.ciss.de/
Sitz der Gesellschaft: Sinzig AG Andernach, HR-Nummer 3357
Geschäftsführer: Dipl.-Math. Joachim Figura, Dipl.-Inform. Berthold Bärk
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 17085
