Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Object Type Error

Re: Object Type Error

From: Ed Prochak <edprochak_at_adelphia.net>
Date: Tue, 01 Apr 2003 21:23:59 GMT
Message-ID: <3E8A0752.8040408@adelphia.net>


Martin Burbridge wrote:
> "Chris \( Val \)" <chrisval_at_bigpond.com.au> wrote in message news:<b6c72k$3kn0m$1_at_ID-110726.news.dfncis.de>...
>

[]
> <snip>
>

>>A person told me during the week that it was not legal to use
>>'%TYPE' in this situation, and this is what I'm not sure about.
>>
>>Could this be the case ?.
>>
>>Thanks.
>>Chris Val

>
>
> Yes you can only use %TYPE in PL/SQL not SQL.
>
> Hth
> Martin

Nice catch, Martin. I totally missed that.

-- 
Ed Prochak
running: http://www.faqs.org/faqs/running-faq/
family:  http://web.magicinterface.com/~collins
--
"Two roads diverged in a wood and I
I took the one less travelled by
and that has made all the difference."
robert frost
Received on Tue Apr 01 2003 - 15:23:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US