Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2013
    Posts
    1

    Unanswered: Execution of Oracle 11g wrapped procedure gives ora-00900 error

    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

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    what version is the database that you are using. The wrap utility has evolved over the years and you should not wrap using a version having a higher revision level then the running database.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •