Home » Developer & Programmer » Forms » Error 103 in my query (Oracle Form 12c)
Error 103 in my query [message #685282] Fri, 03 December 2021 23:05 Go to next message
Muhammad Rafey
Messages: 6
Registered: December 2021
Junior Member
I'm getting ERROR

ERROR 103
"Encountered the symbol "PERM_MAST" when expecting one of the following.
,; for group having intersect minus order start union where connect

This is my code:

select perm_detail.perm_column_value, perm_detail.remarks
into :territorial_scope.country_id, :territorial_scope.display_scope
from perm_detail
join perm_mast
on perm_detail.perm_mast_id = perm_mast.perm_mast_id
where perm_mast.perm_mast_id = perm_detail.perm_mast_id
AND perm_mast.branch_id= :PARAMETER.P_BRANCH
AND perm_detail.perm_column_id=100548;


PICTURE IS ATTACHED FOR REFERENCE
  • Attachment: Capture.PNG
    (Size: 31.18KB, Downloaded 1066 times)
Re: Error 103 in my query [message #685284 is a reply to message #685282] Sat, 04 December 2021 01:23 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

Perhaps the client you are using does not understand ANSI join syntax.
Re: Error 103 in my query [message #685285 is a reply to message #685284] Sat, 04 December 2021 11:55 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In your code:

select perm_detail.perm_column_value, perm_detail.remarks
into :territorial_scope.country_id, :territorial_scope.display_scope
from perm_detail
join perm_mast
on perm_detail.perm_mast_id = perm_mast.perm_mast_id     --> this is the same ...
where perm_mast.perm_mast_id = perm_detail.perm_mast_id  --> ... as this line
AND perm_mast.branch_id= :PARAMETER.P_BRANCH
AND perm_detail.perm_column_id=100548;
As John said, rewrite it to

select d.perm_column_value, 
       d.remarks
  into :territorial_scope.country_id, 
       :territorial_scope.display_scope
  from perm_detail d, perm_mast m
  where d.perm_mast_id = m.perm_mast_id
    and m.branch_id    = :parameter.p_branch
    and d.perm_column_id = 100548;
Re: Error 103 in my query [message #685308 is a reply to message #685285] Mon, 06 December 2021 23:02 Go to previous messageGo to next message
Muhammad Rafey
Messages: 6
Registered: December 2021
Junior Member
Thank you @LittleFoot my error is fixed, but it is only displaying Country Id not the remarks in display_scope column.
Column is set to data type: Char
Re: Error 103 in my query [message #685316 is a reply to message #685308] Tue, 07 December 2021 14:07 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If nothing is displayed, looks like D.REMARKS column is empty. Because, if there were no rows that satisfy the condition, you wouldn't see anything at all (not only REMARKS value).
Re: Error 103 in my query [message #685335 is a reply to message #685316] Thu, 09 December 2021 23:45 Go to previous messageGo to next message
Muhammad Rafey
Messages: 6
Registered: December 2021
Junior Member
it's working fine now, thanks for the help!
Re: Error 103 in my query [message #685338 is a reply to message #685335] Fri, 10 December 2021 14:22 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You're welcome.
Previous Topic: PDF upload as an attachment? (3 merged)
Next Topic: FRM-40112 on go_item to an enabled item
Goto Forum:
  


Current Time: Fri Mar 29 02:15:37 CDT 2024