Re: Problem with Computed Column

The prior poster was a bit off the mark, IMO. The SQL is close to valid (you can put a select statement in place of a column). However, it looks like PD_TYPE does not exist in the dbo.party_dtl table, which is where you are selecting FROM.

Also, the quotations around the view name should probably go away.... otherwise you will have to select * from "viewname"...

-JJ

"TheanKeong" <theankeong_at_gmail.com> wrote in message news:1109565058.254124.119130_at_g14g2000cwa.googlegroups.com...
> Hi,
> I am a newbie in Oracle and I am currently facing a problem with
> migrating my SQL statement to Oracle. The statement looks like this
>
> create or replace view dbo."v_crm_events_detail_analysis" as
> (select pd_type from dbo.party_dtl where pd_id=(select ceh_pt_id from
> dbo.crm_events_hdr where ceh_id=ced_ceh_id) and pd_type in('C','P')) as
> Pd_Type,
>
> (case when Pd_type='C' then 'Customer'
> when Pd_Type='P' then 'Prospect' end) as Party_type,
>
> FROM dbo.Party
>
> I got an error indicating INVALID identifier PD_TYPE. The error happens
> in my Case Section. Is it that Oracle cannot identified COmputed
> Columns in such circumstance or I am doing things wrongly?
> Or is there any workaroung ?
>
> Thanks
> Kwan
>
Received on Mon Feb 28 2005 - 01:25:29 CST