Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"missing expression"

Status
Not open for further replies.

JDogg306

Programmer
Apr 6, 2003
1
0
0
CA
SQL plus is telling me "ORA-00936: missing expression" when I execute this PL/SQL code:
update KingsDepartments
set Professors = Professors_T(
(select Ref(O) from KingsCS O where O.Name = 'Professor Adam'), (select Ref(O2) from KingsCS O2 where O2.Name = 'Professor Alan'))
where Name = 'Computer Science';

And an asterix is placed under the first select. KingsDepartments is a table of Department_T objects, which contain a field Professors_T. Professors_T is a table of oids of objects of the same type as KingsCS contains.
Any idea why I'm getting this error?

Thanks in advance.
 
Hi,

I guess it could be the last where clause which has no function so that the ref will be missing

(select Ref(O) from KingsCS O where O.Name = 'Professor Adam'),
(select Ref(O2) from KingsCS O2 where O2.Name = 'Professor Alan'))
where Name = 'Computer Science';

should be used with AND instead of where ??

regards
Uwe
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top