Re: FW: SQL Error... huh?

From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Mon, 28 Jul 2014 08:51:05 -0600
Message-ID: <53D66359.1000206_at_gmail.com>

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.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 28 2014 - 16:51:05 CEST