OraFAQ Forum: Server Utilities » Execution of Oracle 11g wrapped procedure gives ora-00900 error

Home » RDBMS Server » Server Utilities » Execution of Oracle 11g wrapped procedure gives ora-00900 error (Oracle 11g Wrap Utility)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Execution of Oracle 11g wrapped procedure gives ora-00900 error [message #581312]

Thu, 04 April 2013 06:58

asksrikanth@gmail.com
Messages: 9
Registered: December 2008
Location: Bangalore

Junior Member

Hi,

I have a procedure which i wrapped using the oracle 11g wrap utility. If i execute the wrapped procedure using jdbc i am getting an error of 0RA-00900 invalid sql statement.

The procedure is having basic sql statements only.

The same procedure if i wrap using Oracle 9i and execute using jdbc it works fine.

Is there any change in Oracle 9i wrap utility and Oracle 11g wrap utility.

need help in this regard ASAP

Note: I tried even Oracle 10g wrap it is also not working fine.

Thanks
Sri

[Updated on: Thu, 04 April 2013 06:59]

Report message to a moderator

Re: Execution of Oracle 11g wrapped procedure gives ora-00900 error [message #581314 is a reply to message #581312]

Thu, 04 April 2013 07:03

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Is there any change in Oracle 9i wrap utility and Oracle 11g wrap utility.

Yes, there are many.

Regards
Michel

Report message to a moderator

Re: Execution of Oracle 11g wrapped procedure gives ora-00900 error [message #581315 is a reply to message #581314]

Thu, 04 April 2013 07:04

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Note: I tried even Oracle 10g wrap it is also not working fine.

So why don't you use the 10g wrapper version?

Regards
Michel

[Updated on: Thu, 04 April 2013 07:04]

Report message to a moderator

Re: Execution of Oracle 11g wrapped procedure gives ora-00900 error [message #581318 is a reply to message #581315]

Thu, 04 April 2013 07:22

asksrikanth@gmail.com
Messages: 9
Registered: December 2008
Location: Bangalore

Junior Member

Michel, can you let me know how those changes effect the wrapped procedure execution.

Oracle 10g wrap is having the same problem

Report message to a moderator

Re: Execution of Oracle 11g wrapped procedure gives ora-00900 error [message #581331 is a reply to message #581318]

Thu, 04 April 2013 08:57

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I don't know, it is Oracle internal.
For what I can say is that Oracle improves security by hiding string and other constants.

Quote:

Oracle 10g wrap is having the same problem

So still use 9i version until it fails due to new object types you may use.

regards
Michel

Report message to a moderator

Previous Topic:	ORA-01466: unable to read data - table definition has changed
Next Topic:	Total estimation using BLOCKS method - datapump

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 16:02:03 CST 2025