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?
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
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 UA-cam videos and websites from google .. same error ... don't know where i am making mistake or missing something Thanks and best regards
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?
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
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
how to export this data to excel or pdf
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 UA-cam videos and websites from google .. same error ... don't know where i am making mistake or missing something
Thanks and best regards
I have doubt can you please clarify it