[fdo-users] Re: Number of geometry types in Oracle FeatureClass

[Haris Kurtagic]

Hm, from error itself looks like some issue with provider
but looking into your code sample you used fdo class name instead of
Oracle table name (execute sql will execute sql exactly as you wrote
it).
It looks like, error code  doesn't match sample sql you put in email
sql in email is the one you used it ?

Haris

On Thu, Jun 10, 2010 at 1:26 PM, hanko
<hana.jaborova at spatialtechnology.se> wrote:
>
> Hi,
>
> A Good advice is worth gold
>
> I have already tried use SQL statement command in FDO. I cannot get it work.
> I would appreciate a working code example.
>
> public void SQLQuery()
> {
>        // create the command
>        ISQLCommand sqlCommand =
> (ISQLCommand)FDOConnection.CreateCommand(OSGeo.FDO.Commands.CommandType.CommandType_SQLCommand);
>        int count = 0;
>
>        sql = "SELECT COUNT(1) AS CONT FROM MYTABLE t  WHERE t.GEOMETRY.sdo_gtype
> IN (2001,3001,2005,3005)";
>        //or
>        sql = "SELECT COUNT(1) AS CONT FROM KingOra:MYSCHEMA~MYTABLE~GEOMETRY t
> WHERE t.GEOMETRY.sdo_gtype IN (2001,3001,2005,3005)";
>        sqlCommand.SQLStatement = sql;
>        try
>        {
>                count = sqlCommand.ExecuteNonQuery();
>                //ISQLDataReader dataReader = sqlCommand.ExecuteReader();
>        }
>        catch (OSGeo.FDO.Common.Exception ex)
>        {
>                System.Console.WriteLine(ex.Message +" " + ex.InnerException);
>        }
> }
> Exception: "ora-24374 define not done before fetch or execute and fetch"
> Cheers
>
> Hanko
> --
> View this message in context: http://osgeo-org.1803224.n2.nabble.com/Number-of-geometry-types-in-Oracle-FeatureClass-tp5161882p5162697.html
> Sent from the FDO Users mailing list archive at Nabble.com.
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
>