pragma serial_resuable problem
733256Aug 9 2011 — edited Aug 9 2011create or replace package pkg_serial_reusable
as
pragma serially_reusable;
function sfn_serial_resuable return number;
end pkg_serial_reusable;
create package body pkg_serial_reusable
as
pragma serially_reusable;
function sfn_serial_resuable
return number
as
l_code tmp_employee.code%type;
begin
select code into l_code from tmp_employee where code='90142555';
return l_code;
end sfn_serial_resuable;
end pkg_serial_reusable;
the package body and specification created without any error..but when i am call this function through sql statement its returns a error..the error is
ORA-06534: Cannot access Serially Reusable package "SUKANTA.PKG_SERIAL_REUSABLE"
plzzzzzzzzz help me