Invalid OrgId

29 views
Skip to first unread message

Sarah Kazemi

unread,
May 23, 2018, 1:25:11 AM5/23/18
to COMP9311 Project Q&A
could u please kindly clarify what do u exactly mean exactly by Invalid ORGID as u did before for q1? :)

Paula Kiatkamolwong

unread,
May 23, 2018, 3:12:24 AM5/23/18
to COMP9311 Project Q&A
Hi Sarah,

I think if the user input an orgid that doesn't exist in the table orgunits, then you should raise exception invalid orgid.
Ex. 
select * from q3(20000, 35,100); 
Because there's no organization with the id 20000, the exception invalid orgid is raised

I'm not a tutor, but that's how I did in my solution... you might want to confirm with one of the tutors
Best,
Paula
Reply all
Reply to author
Forward
0 new messages