Re: FW: SQL Error... huh?
- From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- To: Brian Zelli <Brian.Zelli@xxxxxxxxxxxxxxx>
- Date: Mon, 28 Jul 2014 22:01:21 +0700
It's normal and expected. You can't do that.
[oracle@oel6 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Tue May 13 17:26:04 2014
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced
Analytics
and Real Application Testing options
SQL> select * bulk collect into x from dual;
select * bulk collect into x from dual
*
ERROR at line 1:
ORA-03001: unimplemented feature
select .. bulk collect into... is PL/SQL syntax, not SQL syntax.
The error message could be alittle more descriptive, though
On Mon, Jul 28, 2014 at 9:58 PM, Zelli, Brian <Brian.Zelli@xxxxxxxxxxxxxxx>
wrote:
> 11g, HPUX and I tried running it in SQL Developer and got the same
> error…..
>
>
>
>
>
> Brian
>
>
>
>
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Hans Forbrich
> *Sent:* Monday, July 28, 2014 10:51 AM
> *To:* oracle-l@xxxxxxxxxxxxx
> *Subject:* Re: FW: SQL Error... huh?
>
>
>
> Some hints around platform, version, tool used, etc. would be
> appreciated.
>
> Does this run successfully in SQLPlus or SQLDeveloper?
>
> /Hans
>
> On 28/07/2014 8:45 AM, Zelli, Brian wrote:
>
>
>
> A developer tried to run this query below and got the error “ORA-03001:
> unimplemented feature”. He ran “select * from v$option;” and objects are
> enabled… is it a permission item?
>
>
>
> SELECT S_SUBJECTID,
>
> GENDERFLAG,
>
> NULL ,
>
> U_FIRSTNAME,
>
> U_LASTNAME,
>
> U_MIDI,
>
> U_MAIDENNAME,
>
> U_EMAIL,
>
> U_MRN,
>
> U_CITY,
>
> U_STATE,
>
> U_STREET,
>
> U_ZIPCODE,
>
> BIRTHDT,
>
> U_DEATHDT,
>
> NULL ,
>
> U_SSN,
>
> NULL ,
>
> U_PHONE,
>
> NULL ,
>
> NULL BULK COLLECT
>
> INTO PresentValue_Array
>
> FROM S_SUBJECT
>
> ORDER BY S_SUBJECTID
>
>
>
> I did some googling on the error and it doesn’t seem to relate to his
> issue. Any ideas?
>
>
>
> Brian
>
>
>
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
>
Other related posts:
