This forum is currently locked. You can't register or post questions at this time. (read more)

Execution of Oracle 11g wrapped procedure gives ora-00900 er

All posts relating to Oracle database administration.

Moderator: Tim...

asksrikanth
Member
Posts: 3
Joined: Thu Apr 04, 2013 12:19 pm

Execution of Oracle 11g wrapped procedure gives ora-00900 er

Postby asksrikanth » Thu Apr 04, 2013 12:20 pm

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

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Execution of Oracle 11g wrapped procedure gives ora-0090

Postby Tim... » Thu Apr 04, 2013 1:49 pm

Hi.

Oracle regularly change the algorithms for the wrap utility in an attempt to make it more secure. You should only use code that was wrapped using the wrap utility of the same version as the database you are installing it in. I would not recommend attempting to wrap using 9i wrap, then installing in 11g for example.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

asksrikanth
Member
Posts: 3
Joined: Thu Apr 04, 2013 12:19 pm

Re: Execution of Oracle 11g wrapped procedure gives ora-0090

Postby asksrikanth » Fri Apr 05, 2013 4:41 am

Hi Tim,

I agree with you, but the procedure wrapped in Oracle 11g and executing that is giving ORA-00900 error.

Do i need to set any settings for 11g

Regards
Sri

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Execution of Oracle 11g wrapped procedure gives ora-0090

Postby Tim... » Fri Apr 05, 2013 7:54 am

Hi.

No. This works for me:

http://www.oracle-base.com/articles/10g ... -10gr2.php

Are you doing the wrap on your PC or the server? Is is possible you are "accidentially" using and old version?

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Execution of Oracle 11g wrapped procedure gives ora-0090

Postby Tim... » Fri Apr 05, 2013 7:56 am

Hi.

I just had a quick Google and it appears this is a bug in TOAD. Nothing to do with Wrap.

https://support.quest.com/SolutionDetai ... d=SOL37020

Make sure you are on the latest version of TOAD. If you still get the problem, log it with Quest support. They may have introduced the problem again. :)

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

asksrikanth
Member
Posts: 3
Joined: Thu Apr 04, 2013 12:19 pm

Re: Execution of Oracle 11g wrapped procedure gives ora-0090

Postby asksrikanth » Fri Apr 05, 2013 10:02 am

Tim,

I am not using TOAD or any other third part tool, what is do is

I have machine where Oracle 11g is installed i copy the Script.ora into Bin folder and then use the below code for creating Script.plb file

Wrap iname=Script.ora oname=Script.plb

and when i execute the wrapped procedure i end up with below error message

BI3reTc5VzVDkThqqeHk86DcCZf0g62qPr2Z3qdDUKyLVCzUezXOVTsOC/gkVS9u3AwEeZ5F ==> ORA-00900: invalid SQL statement

Sri

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Execution of Oracle 11g wrapped procedure gives ora-0090

Postby Tim... » Fri Apr 05, 2013 10:54 am

Hi.

I'm sorry. I must have had TOAD lodged in my brain from another questions. :(

Note: You've not actually mentioned that you can run the code successfully in the unwrapped state. The fact it works when wrapped in 9i, suggests the code is not at fault, but I think it is worth confirming.

Assuming the code works properly in the unwrapped state, then I think your only option is to contact Oracle support and raise this as a potential bug. Before doing this, make sure you have tested on the latest patchset 11.2.0.3 and PSU.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 11 guests

cron