Home » SQL & PL/SQL » SQL & PL/SQL » Serially Reusable package (oracle 10g)
Serially Reusable package [message #429858] Fri, 06 November 2009 00:28 Go to next message
b_chugh
Messages: 68
Registered: August 2005
Location: delhi
Member
Hi,

I am getting error of ORA-06534-Cannot access Serially Reusable package.
i am using package with PRAGMA SERIALLY_REUSABLE;
and calling this with application developed on (C# and .NET). Does C# and .NET support this SERIALLY_REUSABLE functionality of oracle?

Please suggest that what needs to be done for this?

Thanks.
Re: Serially Reusable package [message #429860 is a reply to message #429858] Fri, 06 November 2009 00:37 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Do you call it from a SQL context?
Re: Serially Reusable package [message #429862 is a reply to message #429858] Fri, 06 November 2009 00:48 Go to previous messageGo to next message
ayush_anand
Messages: 417
Registered: November 2008
Senior Member
ORA-06534: Cannot access Serially Reusable package string 
Cause: The program attempted to access a Serially Reusable package in PL/SQL called from SQL context (trigger or otherwise). Such an access is currently unsupported.
 
Action: Check the program logic and remove any references to Serially Reusable packages (procedure, function or variable references) which might happen in PL/SQL called from sql context (trigger or otherwise).
 
Re: Serially Reusable package [message #429864 is a reply to message #429862] Fri, 06 November 2009 00:52 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
ayush_anand wrote on Fri, 06 November 2009 07:48
ORA-06534: Cannot access Serially Reusable package string 
Cause: The program attempted to access a Serially Reusable package in PL/SQL called from SQL context (trigger or otherwise). Such an access is currently unsupported.
 
Action: Check the program logic and remove any references to Serially Reusable packages (procedure, function or variable references) which might happen in PL/SQL called from sql context (trigger or otherwise).
 

Wow.. you found this all by yourself?
What does this add to my reply?
Re: Serially Reusable package [message #429866 is a reply to message #429864] Fri, 06 November 2009 00:54 Go to previous messageGo to next message
ayush_anand
Messages: 417
Registered: November 2008
Senior Member
Action Wink

Sorry Frank sometimes I post just to be part of that topic that helps increase my GK

[Updated on: Fri, 06 November 2009 01:00]

Report message to a moderator

Re: Serially Reusable package [message #429869 is a reply to message #429864] Fri, 06 November 2009 01:03 Go to previous messageGo to next message
b_chugh
Messages: 68
Registered: August 2005
Location: delhi
Member
it tells to remove the reference to Serially Reusable packages.

means if the package is being called is using Pragma Serially_Reusable, i need to remove that key word?

is there any other way?

[Updated on: Fri, 06 November 2009 01:04]

Report message to a moderator

Re: Serially Reusable package [message #429870 is a reply to message #429869] Fri, 06 November 2009 01:06 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Simply put: you can not call such a package from a SQL statement as indicated in the docs
Previous Topic: Upgrade Publish and Subscribe Model
Next Topic: Sql query related issue
Goto Forum:
  


Current Time: Sun Sep 25 23:12:05 CDT 2016

Total time taken to generate the page: 0.12522 seconds