---
title: "Discussion on \"APEX_UTIL.JSON_FROM_SQL No Rows Bug + Fix\" | Hashnode"
description: "Discussion on \"APEX_UTIL.JSON_FROM_SQL No Rows Bug + Fix\". I ran into an issue yesterday using APEX_UTIL.JSON_FROM_SQL with a query that returned no rows. This function is used in AJAX calls to return the results of a query as a JSON object.\nTo replicate this issue you can do the following in APEX:\n1- Create..."
url: "https://hashnode.com/posts/apexutiljsonfromsql-no-rows-bug-fix/64dcc7ba4429385b92804178"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [APEX\_UTIL.JSON\_FROM\_SQL No Rows Bug + Fix](https://talkapex.com/apexutiljsonfromsql-no-rows-bug-fix?utm_source=hashnode&utm_medium=feed)

I ran into an issue yesterday using APEX\_UTIL.JSON\_FROM\_SQL with a query that returned no rows. This function is used in AJAX calls to return the results of a query as a JSON object. To replicate this issue you can do the following in APEX: 1- Create...

May 26, 2009 · 2 min read · talkapex.com  
Read the article

## Written by

[Martin Giffy D'Souza](https://hashnode.com/@martindsouza)

@martindsouza · Calgary, Alberta, Canada

  
[View profile](https://hashnode.com/@martindsouza)

Oracle APEX Developer

## Responses

Markdown supported · ⌘↵ to post

No responses yet.