Home » Developer & Programmer » Forms » Oracle error Unable to perform query (Oracle form 11g)
Oracle error Unable to perform query [message #667208] Thu, 14 December 2017 21:51 Go to next message
Manish Jha
Messages: 4
Registered: December 2017
Junior Member
Hi all,

I'm facing a problem. In form we merge multiple vouchers together, after merging system will generate a common merge voucher number in the screen corresponding to each voucher. Up to 1000 system is able to merge and query data block to display in the screen. Once we increase to 1001 or more. system unable to query in the screen after merge, it is saying unable to perform query.
below is the code.

varable ct_mv_2 is varchar2 and this variable holds multiple value like ('MVN1','MVN2'............untill 1001 times)
value for MVN1, MVN2 is same.

if ct_mv_2 is not null then
SET_BLOCK_PROPERTY('PYMT_VOU_MASTER',DEFAULT_WHERE,'V_merged_vou_no in '||ct_mv_2);
end if;

GO_BLOCK('PYMT_VOU_MASTER');
EXECUTE_QUERY;

Kindly help and let me know your experience on it.
Re: Oracle error Unable to perform query [message #667217 is a reply to message #667208] Fri, 15 December 2017 03:28 Go to previous messageGo to next message
cookiemonster
Messages: 13292
Registered: September 2008
Location: Rainy Manchester
Senior Member
when ever you get that error you should select "display error" from the runtime help menu - it'll show what the problem with the query is.
Re: Oracle error Unable to perform query [message #667219 is a reply to message #667217] Fri, 15 December 2017 03:33 Go to previous messageGo to next message
Manish Jha
Messages: 4
Registered: December 2017
Junior Member
While doing this, I had stopped my triggers ON_MESSAGE and ON_ERROR. After running pressed Shift+F1- It gave the unable to perform query. Have done in oracle form 11G

Regards,
Manish Jha
Re: Oracle error Unable to perform query [message #667220 is a reply to message #667219] Fri, 15 December 2017 04:56 Go to previous messageGo to next message
cookiemonster
Messages: 13292
Registered: September 2008
Location: Rainy Manchester
Senior Member
Those triggers have nothing to do with display error.
Have you tried using it?
Re: Oracle error Unable to perform query [message #667221 is a reply to message #667220] Fri, 15 December 2017 04:58 Go to previous messageGo to next message
Manish Jha
Messages: 4
Registered: December 2017
Junior Member
Yes, With those triggers. The error was was coming non oracle exception.
Re: Oracle error Unable to perform query [message #667235 is a reply to message #667221] Fri, 15 December 2017 08:16 Go to previous messageGo to next message
cookiemonster
Messages: 13292
Registered: September 2008
Location: Rainy Manchester
Senior Member
You're going to have to explain what you're actually doing with those triggers.
Re: Oracle error Unable to perform query [message #667236 is a reply to message #667235] Fri, 15 December 2017 10:03 Go to previous messageGo to next message
Littlefoot
Messages: 21439
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd say that "1000" is the keyword here. IN can contain up to 1000 elements (as the OP said in the initial message):Quote:

Up to 1000 system is able to merge and query data ...

varable ct_mv_2 is varchar2 and this variable holds multiple value like ('MVN1','MVN2'............until 1001 times)
This is a know restriction.

So, if you have to deal with more than 1000 elements in the IN list, the simplest solution is to store them into a table (you know, INSERT INTO ...) and use that table in subquery as
SET_BLOCK_PROPERTY
  ('PYMT_VOU_MASTER',
    DEFAULT_WHERE,
   'V_merged_vou_no in (select column_name from your_table)'
  );

[Updated on: Fri, 15 December 2017 10:03]

Report message to a moderator

Re: Oracle error Unable to perform query [message #667240 is a reply to message #667236] Sat, 16 December 2017 22:21 Go to previous message
Manish Jha
Messages: 4
Registered: December 2017
Junior Member
Yes, I also felt the same. IN got some limitation. Thanks for your relies guys.
Previous Topic: Analytical Laboratories system
Next Topic: Browse Button
Goto Forum:
  


Current Time: Mon Oct 22 22:07:13 CDT 2018