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 derfloh 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
Joined
Apr 6, 2003
Messages
1
Location
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