sql - ORA-00907: missing right parenthesis 00907. 00000 - "missing right parenthesis" *Cause: *Action: Error at Line: 44 Column: 30 -
i executing following query:
select * (select * (select distinct r.llobjid dataid, r.drawingid, r.revisionid, r.revisionnumber revision_number, r.revisionlabel, r.minorrevisionlabel, r.revisiontype, p.project project, r.revisionstatus, r.r1i signin_requestor, r.r2i seedfileversion, rt.display_type_name revision_type, rt.can_signin, rs.display_status_name revision_status, a.adntypeid, at.name adn_type, a.requestby, a.assignbyas assign_by_id, ' ' assign_by, a.assigndate, ' ' assign_date adnids inner join crt_revision r on r.drawingid = a.adnid , upper(a.wholeid) '4160%' inner join adntypes @ on a.adntypeid = at.adntypeid , at.orgunitid = 21 inner join crt_project p on r.projectid = p.projectid , p.ouid = 21 left outer join crt_revision_type_map rt on r.revisiontype = rt.revtypeid , rt.ouid = 21 left outer join crt_revision_status_map rs on r.revisionstatus = rs.revstatusid , rs.ouid = 21 ( r.revisionstatus = 2 )) tbl1 inner join (select distinct d.dataid lldataid, cast(d.dcomment nvarchar(4000)) title, d.name document_name, d.createdate created_date, d.modifydate modified_date, d.subtype, d.versionnum, d.permid, d.reserved, d.ownerid crt_revision r3 inner join adnids a3 on r3.drawingid = a3.adnid , upper(a3.wholeid) '4160%' inner join dtree d on r3.llobjid = d.dataid ( r3.revisionstatus = 2 )) tbl2 on tbl1.dataid = tbl2.lldataid left outer join (select distinct l.dataid asm_dataid, l.stateid, l.intransition, ls.name current_state, ls.signin, ls.lifecycleid, ll.name lifecycle crt_revision r5 inner join adnids a5 on r5.drawingid = a5.adnid , upper(a5.wholeid) '4160%' inner join lm_lifecycles l on l.dataid = r5.llobjid inner join lm_def_states ls on l.stateid = ls.stateid inner join lm_def_lifecycles ll on ls.lifecycleid = ll.lifecycleid ( r5.revisionstatus = 2 )) tbl4 on tbl1.dataid = tbl4.asm_dataid ( exists (select b.dataid dtreeacl b b.dataid = nvl(tbl2.permid, tbl2.lldataid) , ( rightid in ( -2, -1, 1000, 1001 ) ) , see > 0) ) order modified_date desc) tbl100 rownum <= 25 oracle sql developer throws error as: ora-00907: missing right parenthesis
it looks fine don't understand getting error of missing right parenthesis.
it because of cast(d.dcomment nvarchar(4000)). nvarchar not valid data type.
change cast(d.dcomment nvarchar2(2000))
it work
in fiddle sample
select cast('ddd' nvarchar2(2000)) dd dual if change in to
select cast('ddd' nvarchar(2000)) dd dual you error
ora-00907: missing right parenthesis
Comments
Post a Comment