Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

invalid boolean datatype when creating a table

579235Aug 20 2007 — edited Aug 20 2007
hii,
I am trying to create a table with columns as name, autogenerated id, and another column with boolean datatype. but it gives error.

1 create table cust_id
2* ( name varchar(30), id number, allposts BOOLEAN)
SQL> /
( name varchar(30), id number, allposts BOOLEAN)
*
ERROR at line 2:
ORA-00902: invalid datatype.

plz help

Comments

3290630

HI Robin

          I have been following your posts and this is about your article n upgrading obiee 11.1.1.6 to 11.1.1.7 which was very nice however i encountered a problem when trying to run config.bat on windows. All other steps ran file but when i was trying to run the step for E:\OFMHomeDev\Oracle_BI1\bin\config.bat, it gave error such as "INST-0866: Weblogic cluster ‘bi_cluster’ is not present in this domain. This may be because the BI System is created through “Simple Install” Option which is not supported for scale out and update domain". I am confident that  it was install as Enterprise install so i am just wondering if you have seen such errors or any clue about this. Since I am little behind on the upgrade, its hard to find the right article and i have opened the oracle ticket and no luck so far. Sorry, posting it on wrong area but if you see this message please let me know at dpksubedi@gmail.com.

thanks again

https://www.rittmanmead.com/blog/2013/04/upgrading-obiee-to-11-1-1-7/

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 17 2007
Added on Aug 20 2007
3 comments
1,499 views