OraFAQ Forum: Forms » Oracle error Unable to perform query

Home » Developer & Programmer » Forms » Oracle error Unable to perform query (Oracle form 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle error Unable to perform query [message #667208]

Thu, 14 December 2017 21:51

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.

Report message to a moderator

Re: Oracle error Unable to perform query [message #667217 is a reply to message #667208]

Fri, 15 December 2017 03:28

cookiemonster
Messages: 13966
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.

Report message to a moderator

Re: Oracle error Unable to perform query [message #667219 is a reply to message #667217]

Fri, 15 December 2017 03:33

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

Report message to a moderator

Re: Oracle error Unable to perform query [message #667220 is a reply to message #667219]

Fri, 15 December 2017 04:56

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

Those triggers have nothing to do with display error.
Have you tried using it?

Report message to a moderator

Re: Oracle error Unable to perform query [message #667221 is a reply to message #667220]

Fri, 15 December 2017 04:58

Manish Jha
Messages: 4
Registered: December 2017

Junior Member

Yes, With those triggers. The error was was coming non oracle exception.

Report message to a moderator

Re: Oracle error Unable to perform query [message #667235 is a reply to message #667221]

Fri, 15 December 2017 08:16

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

You're going to have to explain what you're actually doing with those triggers.

Report message to a moderator

Re: Oracle error Unable to perform query [message #667236 is a reply to message #667235]

Fri, 15 December 2017 10:03

Littlefoot
Messages: 21823
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

Code: [Select all] [Show/ hide]

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

Manish Jha
Messages: 4
Registered: December 2017

Junior Member

Yes, I also felt the same. IN got some limitation. Thanks for your relies guys.

Report message to a moderator

Previous Topic:	Analytical Laboratories system
Next Topic:	Browse Button

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 17 06:22:44 CDT 2025