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.

Some of the 12c features not working

SamFisherAug 6 2015 — edited Aug 7 2015

Hello All,

Oracle Version:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production0
2PL/SQL Release 12.1.0.2.0 - Production0
3CORE 12.1.0.2.0 Production0
4TNS for Linux: Version 12.1.0.2.0 - Production0
5NLSRTL Version 12.1.0.2.0 - Production

I am trying to use some of the Oracle 12c's new features. But I couldn't.

  1. CREATE TABLE TEST_SK (COL1 NUMBER, COL2 VARCHAR2(32000));

        Ora- 00910: Specified length length too long for its datatype.

    2. CREATE TABLE TEST_SK (COL1 NUMBER GENERATED ALWAYS AS IDENTITY);

        Ora- 00406: Compatible parameter needs to be 12.0.0.0.0 or greater

    3. Inline functions or Inline procedures didn't work too.

But Fetch first N rows is working fine.

Please help me understand if there should be any privileges to make use these new features?
This post has been answered by unknown-7404 on Aug 6 2015
Jump to Answer

Comments

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

Post Details

Locked on Sep 4 2015
Added on Aug 6 2015
3 comments
885 views