• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6944
  • Last Modified:

FRM-30064 / FRM-30085 + ORA-00942 Errors

Hello,

Here is the error message that I get after compiling one of my forms:
---
FRM-30064: Unable to parse statement select am.customer, am.name1, am.phone from armaster am where 0 < (select sum(nvl(balance,0)) from arsumbal as2 where as2.customer = am.customer) order by name1.
ORA-00942: table or view does not exist
Record Group REC_CUST_GROUP
Form: ACC_REC
 
FRM-30085: Unable to adjust form for output.
 
 
Form not created
----

1) How can I resolve this issue ?

PT
0
ptreves
Asked:
ptreves
  • 2
1 Solution
 
Helena Markováprogrammer-analystCommented:
FRM-30064:  Unable to parse statement %s.

Cause:      A syntax error occurred in the SELECT statement within an LOV or record group.

Action:      Check the statement, and add the FROM clause.

You can try to change the record group query to this:

select am.customer, am.name1, am.phone from armaster am where 0 < (select sum(nvl(as2.balance,0)) from arsumbal as2 where as2.customer=am.customer) order by am.name1.
0
 
anand_2000vCommented:
Simple check whether the tables "armaster" and "arsumbal" exist in your schema....One or both might be missing or the name might have been given wrong.
0
 
ptrevesAuthor Commented:
Hello,

Yes, I checked and the tables armaster and arsumbal do exist in the ORacle 9i database.

1) Your toughts ...

PT
0
 
anand_2000vCommented:
What about the login that you are using? are these tables or are they synonyms? do the actual tables belong to some other user? have these been granted to you via a role or directly. If via a role then you might face this problem. grant the tables directly.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now