CODEWITHSUNDEEP
oracle-databaseoracle-apexoracle-apex-5.1oracle-apex-19.1oracle-apex-19.2
Priya Srivatsa
Priya Srivatsa

Reputation: 23

PL/SQL Dynamic content is not displaying in Oracle Apex

I am trying to display the results of a query in a region. However, the region just displays "New" and not the actual output. Could you please help?

PL/SQL code:

DECLARE

V_APP_COUNT NUMBER; BEGIN

SELECT COUNT(*)  INTO V_APP_COUNT FROM APPLICATION;
DBMS_OUTPUT.PUT_LINE(V_APP_COUNT);

END;

Page designer with PL/SQL code

Display page

Upvotes: 0

Views: 867

Answers (1)

Littlefoot
Littlefoot

Reputation: 142713

Query you posted suits better to a report (pick any you want - interactive, classic or grid), not to PL/SQL Dynamic Content. It expects from you to actually "draw" the page using HTML code. Basically, your PL/SQL would use htp.p calls in order to display the result.

As I said - use a report.

Upvotes: 2

Related Questions