Hi
I get this error
when I try to run this simple validation function :
declare
y number;
x varchar2 (512) ;
begin
x := 'select count(*) from acl_employees where UPPER(userid) = upper (:P17_MAIL)
and APPLICATION_ID = :APP_ID ' ;
execute immediate X into Y ;
return Y > 0 ;
end ;
P17-EMAIL is an item of the current page. table structure is as follow :
CREATE TABLE "ACL_EMPLOYEES"
( "ID" NUMBER,
"FIRST_NAME" VARCHAR2(30 BYTE) NOT NULL ENABLE,
"LAST_NAME" VARCHAR2(30 BYTE) NOT NULL ENABLE,
"USERID" VARCHAR2(50 BYTE) NOT NULL ENABLE,
"MOT_DE_PASSE" VARCHAR2(40 BYTE) NOT NULL ENABLE,
"APPLICATION_ID" NUMBER NOT NULL ENABLE,
"EMAIL" VARCHAR2(50 BYTE) NOT NULL ENABLE,
"TOKEN" VARCHAR2(25 BYTE),
)
I don't know how to debug this function under SQL Developer.
Regards.