unable to perform query, but no logged errors [message #612710] |
Wed, 23 April 2014 11:35 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/adbbb566a673e44bf36ae6fa19c3717d?s=64&d=mm&r=g) |
bonbonbaron
Messages: 2 Registered: April 2014
|
Junior Member |
|
|
Hi all, I'm using Oracle Forms Builder 10g.
After I fill out my form on block 1, page 1, it's supposed to take me to block 2, which is on page 2. Block 2's data block wizard has a built-in query which grabs things I typed into block 1 as parameters. (A packaged procedure contains the query.)
The button I click on page 1 has a when-button-pressed trigger as follows:
GO_BLOCK('S02');
EXECUTE_QUERY;
It takes me there alright, but it gives me an FRM-40505 message saying, "ORACLE error: unable to perform query." However, when I try to display the error, I see this: "FRM-42100: No errors encountered recently."
The query itself is okay, because I've tested it out in Oracle SQL Developer.
What kinds of things usually cause this error? Just so I know what to check for. Thanks in advance.
|
|
|
|
|
Re: unable to perform query, but no logged errors [message #612722 is a reply to message #612717] |
Wed, 23 April 2014 14:19 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Is that so? I've never heard of such a restriction and can't see any benefit from preventing developers in debugging their code. Just wondering - did you properly run it? Set a breakpoint into that WHEN-BUTTON-PRESSED trigger and push the "run in debug mode" green button. If you still can't do that, well, that's a shame. Talk to people who set it up that way and ask them to allow debugging.
Anyway: what does this mean:Quote:
Block 2's data block wizard has a built-in query What is a "built-in query"? If block 2 is a data block, you don't need to write any kind of a query - EXECUTE_QUERY is more or lees all you need. It would certainly fetch some data (if it exists) so you can only refine it (by using SET_BLOCK_PROPERTY and its, for example, ONETIME_WHERE). However, even if you don't write a single line of code, it *would* work properly.
So: try to comment that "built-in query" and run the form again. What happens?
|
|
|
|