what is the correct syntax for calling function/procedure in a stored procedure??
when there is a package called 'ABC'
procedure 'DEF'
function 'KLM'
sruthykmenon
Last Activity: Nov 1 '07, 09:29 AM
Joined: Sep 25 '07
Location:
-
find difficulty in executing this function
create or replace function FUNCTION kassfunc(abc IN VARCHAR2 , def IN VARCHAR2 )
RETURN boolean IS
kasssuccesscode boolean;
kassexchangeId number ;
BEGIN
select count(*) into kassexchangeId from kass where exchange_id = abc || '/' || def ;
if kassexchangeId< > 0
then
kasssuccesscode := true ;
else
kasssuccesscode := false;
end...
No activity results to display