Members   Search   Help    Register    Login   Home
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: 48
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.
Report message to a moderator
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: 7317
Registered: March 2000
Senior Member
Do you call it from a SQL context?
Report message to a moderator
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: 270
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).
Report message to a moderator
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: 7317
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?
Report message to a moderator
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: 270
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: 48
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: 7317
Registered: March 2000
Senior Member
Simply put: you can not call such a package from a SQL statement as indicated in the docs
Report message to a moderator
Previous Topic:Upgrade Publish and Subscribe Model
Next Topic:Sql query related issue
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 1 06:16:15 CST 2009

Total time taken to generate the page: 0.37361 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.