Oracle APEX - PL SQL Dynamic Content

Oracle APEX - PL SQL Dynamic Content
Overview -
PL/SQL Dynamic Content region is based on PL/SQL enable you to render any HTML or text using the PL/SQL Web Toolkit.
Instructions -
1. In Page Designer, select a region
2. Go to Property Editor
3. Under the Region tab
Find Identification → Type, use PL/SQL
#orclapex #sql #plsql #codewithsaurav

[@ThePurplePetals]

I am using a shuttle type. When I am trying to insert those shuttle values in table. It is not working. Just coming ::: Not coming the values

[@swamyseeta1482]

Hi, i used the same sample code for dynamic display. but, in the pl code it is showing ORA-06503: PL/SQL: Function returned without value . I did't wrote any function but is it showing like that, how over come it

[@meandmydodge]

Hi Saurav, I am new in Apex ... facing an issue ... Can you help please ? Developing simple user authentication page from Database Table ... and getting below error: ORA-06550: line 4, column 23: PLS-00306: wrong number or types of arguments in call to "VALIDATE_USER" Here is Function which is basic thing ... create or replace FUNCTION VALIDATE_USER (P_UN VARCHAR2, P_PW VARCHAR2) RETURN BOOLEAN IS CNT NUMBER(1); BEGIN SELECT 1 INTO CNT FROM EMPCREDENTIALS WHERE UN = P_UN AND PW = P_PW; RETURN (TRUE); EXCEPTION WHEN NO_DATA_FOUND THEN RETURN (FALSE) ; END; Tried multiple KZbin videos and websites from google .. same error ... don't know where i am making mistake or missing something Thanks and best regards

[@yakaka1]

how to export this data to excel or pdf

[@arunkumarcn440]

I have doubt can you please clarify it