Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

pragma serial_resuable problem

733256Aug 9 2011 — edited Aug 9 2011
create 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
This post has been answered by 32685 on Aug 9 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 6 2011
Added on Aug 9 2011
2 comments
443 views