Skip to Main Content

DevOps, CI/CD and Automation

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.

Software download Issue

User9546983-OracleFeb 7 2014 — edited Feb 7 2014

hello OTN team , this is Mohamed from Oracle Hub team

customer is asking if she can download software

Oracle Business Intelligence, v. 11.1.1.6.0 for Linux x86-64-bit

----------------------------------------------------------------

    - http://download.oracle.com/otn/linux/bi/111160/bi_linux_x86_111160_64_disk1_1of2.zip

    - http://download.oracle.com/otn/linux/bi/111160/bi_linux_x86_111160_64_disk1_2of2.zip

    - http://download.oracle.com/otn/linux/bi/111160/bi_linux_x86_111160_64_disk2_1of2.zip

    - http://download.oracle.com/otn/linux/bi/111160/bi_linux_x86_111160_64_disk2_2of2.zip

    - http://download.oracle.com/otn/linux/bi/111160/bi_linux_x86_111160_64_disk3.zip

Database

--------

- 11.2.0.3.0 PATCH SET FOR ORACLE DATABASE SERVER (Patchset):

    - https://updates.oracle.com/Orion/Services/download/p10404530_112030_Linux-x86-64_1of7.zip?aru=14125322&patch_file=p10404530_112030_Linux-x86-64_1of7.zip

    - https://updates.oracle.com/Orion/Services/download/p10404530_112030_Linux-x86-64_2of7.zip?aru=14125322&patch_file=p10404530_112030_Linux-x86-64_2of7.zip

    - https://updates.oracle.com/Orion/Services/download/p10404530_112030_Linux-x86-64_3of7.zip?aru=14125322&patch_file=p10404530_112030_Linux-x86-64_3of7.zip

    - https://updates.oracle.com/Orion/Services/download/p10404530_112030_Linux-x86-64_4of7.zip?aru=14125322&patch_file=p10404530_112030_Linux-x86-64_4of7.zip

    - https://updates.oracle.com/Orion/Services/download/p10404530_112030_Linux-x86-64_5of7.zip?aru=14125322&patch_file=p10404530_112030_Linux-x86-64_5of7.zip

    - https://updates.oracle.com/Orion/Services/download/p10404530_112030_Linux-x86-64_6of7.zip?aru=14125322&patch_file=p10404530_112030_Linux-x86-64_6of7.zip

    - https://updates.oracle.com/Orion/Services/download/p10404530_112030_Linux-x86-64_7of7.zip?aru=14125322&patch_file=p10404530_112030_Linux-x86-64_7of7.zip

- Patches:

    - Patch 6880880: https://updates.oracle.com/Orion/Services/download/p6880880_112000_Linux-x86-64.zip?aru=17071946&patch_file=p6880880_112000_Linux-x86-64.zip

    - DATABASE PATCH SET UPDATE 11.2.0.3.8 (INCLUDES CPUOCT2013) (Patch):

        - https://updates.oracle.com/Orion/Services/download/p16902043_112030_Linux-x86-64.zip?aru=16676143&patch_file=p16902043_112030_Linux-x86-64.zip

Weblogic

--------

- Application Development Runtime 11.1.1.7: http://download.oracle.com/otn/nt/middleware/11g/111170/ofm_appdev_generic_11.1.1.7.0_disk1_1of1.zip?AuthParam=1391182304_7f666a8c040f68f34f95f45885c01abe

- ADF Patch 17346704: https://updates.oracle.com/Orion/Services/download/p17346704_111170_Generic.zip?aru=16916350&patch_file=p17346704_111170_Generic.zip

- WLS PATCH SET UPDATE 10.3.6.0.6 (Patch): https://updates.oracle.com/Orion/Services/download/p17071663_1036_Generic.zip?aru=16801785&patch_file=p17071663_1036_Generic.zip

please advise

Mohamed Ismail

Comments

Answer

rqEval can accept non-numeric types as input.

In your example, 'select 1 "Industry" forces a returned numeric value.  It fails because the data returned contains 1 non-numeric column. The output doesn't match the specification in the SQL provided, and an error is returned.

Instead, use cast to return as varchar as follows:

SQL> select * from table(rqEval(

        NULL,

        'select cast(''Industry'' as varchar2(8)) "Industry" from dual',

       'Test'));

Returns:

1 Text

Marked as Answer by 3631507 · Sep 27 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 7 2014
Added on Feb 7 2014
4 comments
6,314 views