Tuesday, March 5, 2024

Bugs in Oracle Apex 23.2 and ORDS 23.4

I have recently installed Apex 23.2, ORDS 23.4 for POC purpose and come across below issues when working with APEX and ORDS.

Bug: Oracle Apex 23.2 with Interactive Grid

When working with Interactive Grid, the filters saved in the Interactive Grid not displaying correct values. The issue happens intermittently, and filter values change from date to string or filter operators may drop out of the list.

When users working with operators they see inconsistency in the values, which is a big concern.

After research I found that its known issue ang filed bug #36200437

For more detailed info please check below Oracle forum link

BUG in APEX 23.2 Interactive Grid: Multiple Criteria Filter Issue - Oracle Forums

Bug: ORDS 23.4 with PL/SQL

Please see the cause and action for error PLS-00306: wrong number or types of arguments in call to 'string”

Cause: 
This error occurs when the named subprogram call cannot be matched to any declaration for that subprogram name. The subprogram name might be misspelled, a parameter might have the wrong datatype, the declaration might be faulty, or the declaration might be placed incorrectly in the block structure. For example, this error occurs if the built-in square root function SQRT is called with a misspelled name or with a parameter of the wrong datatype.

Action: 
Check the spelling and declaration of the subprogram name. Also confirm that its call is correct, its parameters are of the right datatype, and, if it is not a built-in function, that its declaration is placed correctly in the block structure.

But in my case when working with PL/SQL code users receiving “PLS-00306: wrong number or types of arguments in call”. The same code works after some time, after research found that it’s a known bug.

For more details, please see the below Oracle forums link.

ORDS 23.4 with PL/SQL. PLS-00306: wrong number or types of arguments in call to - Oracle Forums

Hope this helps.

Thanks & Regards.
Satishbabu Gunukula, Oracle ACE Pro

5 comments:

  1. This is a very effective post, also there is a very popular and reliable CIPD assignment help UAE available for new learners to get good academic results.

    ReplyDelete
  2. 급하게 자금이 필요할 때 소액현금화는 꽤 실용적인 소액결제 생각합니다. 빠른 처리 덕분에 시간 절약이 가능했고, 전체적인 과정도 어렵지 않았습니다.

    ReplyDelete
  3. 다양한 업무 정보가 한눈에 정리되어 있어 비교하기 쉬웠습니다. 밤알바 플랫폼은 접근성이 좋아 모바일에서도 편리하게 확인할 수 있었고 진행 속도도 빨라 만족스러웠습니다.

    ReplyDelete
  4. 상담 응대가 친절하고 처리 과정이 투명하게 안내되어 안심하고 이용할 수 있었어요. 상품권현금 진행 중에도 확인 메시지가 꼼꼼하게 제공되어 신뢰가 갔고 예상보다 빠르게 마무리되어 만족스러웠습니다.

    ReplyDelete
  5. 늦은 시간에도 예약 진행이 빨라서 바쁜 직장인에게 정말 유용했어요. 성남출장마사지 서비스는 관리사의 응대가 친절하고 압 조절도 꼼꼼해서 피로 회복에 도움이 되었고 편안한 분위기까지 마음에 들었습니다.

    ReplyDelete