Home » SQL & PL/SQL » SQL & PL/SQL » Wrapped procedure help please (Oracle 10g)
icon5.gif  Wrapped procedure help please [message #434366] Tue, 08 December 2009 23:59 Go to next message
Mohsin_Tm
Messages: 15
Registered: December 2009
Location: Pune
Junior Member
Hi,

Please can anybody let me know how to see source code of a wrapped procedure.

Is there any method to unwrap that procedure which is wrapped.

Thanks in advance.
Re: Wrapped procedure help please [message #434368 is a reply to message #434366] Wed, 09 December 2009 00:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't and this is the main purpose of wrapping.

Regards
Michel
Re: Wrapped procedure help please [message #434369 is a reply to message #434366] Wed, 09 December 2009 00:01 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
>Is there any method to unwrap that procedure which is wrapped.
NO!
Re: Wrapped procedure help please [message #434384 is a reply to message #434366] Wed, 09 December 2009 02:03 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Mohsin_Tm wrote on Wed, 09 December 2009 11:29
Please can anybody let me know how to see source code of a wrapped procedure.


Ask your DBA About your input file.(based on which the Procedure wrapped,assuming not created/supplied by ORACLE ).
That is the only way.

sriram Smile
Re: Wrapped procedure help please [message #434404 is a reply to message #434384] Wed, 09 December 2009 03:03 Go to previous messageGo to next message
Mohsin_Tm
Messages: 15
Registered: December 2009
Location: Pune
Junior Member
hi
i came to know that SYS.SOURCE$ table contain source code for wrapped one.

will any body can help me how to get from it

thanks in advance.
Re: Wrapped procedure help please [message #434407 is a reply to message #434404] Wed, 09 December 2009 03:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you read the previous answers?

Regards
Michel
Re: Wrapped procedure help please [message #434408 is a reply to message #434404] Wed, 09 December 2009 03:08 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Why do you not have access to the unwrapped source code?

Are you trying to access code that is someone else's intellectual property without their permission?
Re: Wrapped procedure help please [message #434423 is a reply to message #434408] Wed, 09 December 2009 03:57 Go to previous messageGo to next message
Mohsin_Tm
Messages: 15
Registered: December 2009
Location: Pune
Junior Member
No JRowbottom i have a procedure which is wrapped and geting error when i am executing it previously it is working fine but after a new cartridger implementation i am facing this problem.

I search lot to find source code for that wrapped proc. I have contected to dba also but there is no responce from there side. and i am unable to find it and i have to close that issue as soon as psbl.


Re: Wrapped procedure help please [message #434424 is a reply to message #434423] Wed, 09 December 2009 04:01 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Mohsin_Tm wrote on Wed, 09 December 2009 15:27
No JRowbottom i have a procedure which is wrapped and geting error when i am executing it previously it is working fine


No error mentioned in your post ..How we know that there is some error in your procedure post what you did and what you got..


sriram

[Updated on: Wed, 09 December 2009 04:02]

Report message to a moderator

Re: Wrapped procedure help please [message #434425 is a reply to message #434423] Wed, 09 December 2009 04:06 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I'm afraid there's nothing we can do on this one - if you can't get the original source code then you'll have to try to work round the problem some other way.
Re: Wrapped procedure help please [message #434436 is a reply to message #434425] Wed, 09 December 2009 05:04 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Having been in the same boat:

You can't unwrap it, but you can still trace what it is actually doing, and so maybe find the cause for the problem. Most of the times that has been enough for me to spot the error and work around it.
Previous Topic: Problem in incrementing the column value
Next Topic: execute a procedure automatically
Goto Forum:
  


Current Time: Tue Dec 06 14:35:53 CST 2016

Total time taken to generate the page: 0.06566 seconds