I am trying to get the following PL/SQL statement to work in a package, but have not had any success.
I have created a function called ISDATE - The ddl is below:
create or replace function isdate
( p_string in varchar2,
p_fmt in varchar2 := null)
when others then
I perform the following select statement:
SELECT TRANSACTIONPROCESSDT INTO VTRANPRODTCHAR FROM TABLE1
VTRANPRODCHAR is defined as a BOOLEAN;
I perform my test
IF ISDATE(VTRANPRODTCHAR,'DD-Mon-YYYY') = 'FALSE'