Oracle APEX - PL SQL Dynamic Content

preview_player
Показать описание
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
Рекомендации по теме
Комментарии
Автор

I would like to use this component to simulate a sqldeveloper where I would type the query and the answer would be placed in a grid or other component. Is this possible?

bandaavapor
Автор

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

ThePurplePetals
Автор

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

swamyseeta
Автор

how to export this data to excel or pdf

yakaka
Автор

I have doubt can you please clarify it

arunkumarcn
Автор

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 Youtube videos and websites from google .. same error ... don't know where i am making mistake or missing something

Thanks and best regards

meandmydodge