in
All Tags » Oracle (RSS)

Browse by Tags

  • Oracle's equivalent for MS SQL's bit data type

    Hi everyone, I have created a DB in MS SQL which has bit columns in most tables. These are nicely translated to boolean properties in SubSonic entities. Now I have to also create the same DB in Oracle. My question is, what do you guys use in Oracle to represent boolean/bit columns? Many thanks...
    Posted to Alternate Providers: MySql, Oracle,etc. (Forum) by danywu on 04-20-2008

  • Oracle Provider Not Generating Views

    I wamt to generate a class object for just 1 database object which happens to be a view. A PK should not be preventing this from working. When I run SubCommander, nothing is generated. <connectionStrings> <add name="AppConnection" providerName="System.Data.OracleClient" connectionString...
    Posted to Alternate Providers: MySql, Oracle,etc. (Forum) by davids on 04-18-2008

  • Paging Sql generates invalid code for Oracle

    I followed the directions on the Webcast: Using Paging using an Oracle Database and got the following error: SQL Error: ORA-00911: invalid character 00911. 00000 - "invalid character" *Cause: identifiers may not start with any ASCII character other than letters and numbers. $#_ are also allowed...
    Posted to Alternate Providers: MySql, Oracle,etc. (Forum) by ej2 on 03-24-2008

  • Re: Oracle Transaction error

    Thanks for your response yitzchok. That page is where I found the code for doing a "pass through" transaction in the first place. Unfortunately, that is what is not working. I haven't explored whether the other types of transactions will work for me, but I don't want to rely on DTC...
    Posted to Code Discussion (Forum) by twayson on 01-14-2008

  • Oracle Transaction error

    I'm using the OracleProvider and I'm trying to execute 2 delete commands against 2 different tables w/in a transaction. I can execute each on it's own (see commented lines below), but when I try to add the commands to a QueryCommandCollection and execute w/ a transaction, I get the following...
    Posted to Code Discussion (Forum) by twayson on 01-11-2008
Page 1 of 1 (5 items)