Questions on Import

[diegopedrao]

Do the following ... Loga as SYS and DBA right for FPW ... it must be some object that you have no right.

ATT,

Diego Monteiro

[dannbook]

I gave DBA permission for the scheme owner and I recompile some disappeared and the same still persists only that there is another error message in compilation:

Select all

PCK_PIR_UTILS compiled with errors, 
 
PLS-00753: unidade encapsulada corrompida ou incorreta.

[diegopedrao]

Take the whole package body and glue in an editor in Sqldeveloper and sends compiling it will point the line where the error and the error itself, then you put for people.

ATT,

Diego Monteiro

[diegolenhardt]

or then show error;

[dannbook]

I think I made a bullshit, I had two users owner. with no user or sys with sys this in the application, but in the PL with them and the application appeared other errors:

- it was not possible to validate the user login and password in the system usage table
- ORA-00980: The translation of synonym is not valid;

[Trevisolli]

Or even, complementing the good definition of our friend Diego, put a default value for this column of the table, if you have it.

[dannbook]

I think I made a bullshit, I had two users owner. with no user or sys with sys this in the application, but in the PL with them and the application appeared other errors:

- it was not possible to validate the user login and password in the system usage table
- ORA-00980: The translation of synonym is not valid;

[diegopedrao]

Dannbook,

sincerely I think you made a shocking ... I think you'd better set up your 0 program, because it already gave so much mistake that fixes one and a lot appears. : Cry:

This error that happens is that it is no longer possible to log in to the user who is configured the application, probably he sought a synonym of this user that you deleted and did not obviously found.

If you need more help is to post.

ATT,

Diego Monteiro

[dannbook]

Ok, I was able to recover as previously the problem is still a single package;
that are the same packages errors past below;

[diegopedrao]

Dannook,

Do as I and Diego said, picks up the package compiles it in SQL Plus or SQL Developer and see the error and post here.

Note: If it is in SQLPlus after compiling run the command: show error

att,

Diego Monteiro

[dannbook]

See:

Select all

SQL> show error; 
Errors for PACKAGE BODY PIRAMIDE.PCK_PIR_UTILS: 
  
LINE/COL ERROR 
-------- ---------------------------------------------- 
0/0      PLS-00753: malformed or corrupted wrapped unit 
  
SQL>

[diegolenhardt]

Are the bank objects encrypted?

Wrapped?

Have you migrated from bankruptcy?

May be ...

Can not get the unwrapped package code?

has an Internet site that does the unwrapped Objects of Oracle:
http://technology.amis.nl/blog/4753/unw ... pped-plsql
I think that's the one, but here it's blocked I can not see. ..

[dannbook]

I think they are yes, take a look at the package below:

Select all

CREATE OR REPLACE Package Body PIRAMIDE.PCK_PIR_UTILS wrapped 
  2  a000000 
  3  1f 
  4  abcd 
  5  abcd 
  6  abcd 
  7  abcd 
  8  abcd 
  9  abcd 
 10  abcd 
 11  abcd 
 12  abcd 
 13  abcd 
 14  abcd 
 15  abcd 
 16  abcd 
 17  abcd 
 18  abcd 
 19  b 
 20  1b1f1 fe74 
 21  ooAWFIG2Dg26KdzgjEGlKn2oHNowg4rtebd2xPfRkr6l1UH9SQRV7Uj+Q2nC/jCX7fMRyphb 
 22  dsMbdWey+nOsBKELpGDIdk+oQ7RXrySY7ij9wWr5BwW7605g8H76p2QqK3VVZ8lm94XPZZlM 
 23  AvI8kINEOBv5KvHaOz4RzQzjiKj963XoClnlUfgZm3vMQbiaPVwSmFGF+uXNm2LxMu+Ujc9n 
 24  KUaZ7cXEWsQ7wC5TiMN3InxITJ++Wv1r9oPRlkiz0bpIJeHVBtE+AfYMIO9hDxsFqk/YBOr1 
 25  E7Wnd04v1vAeJtitFZ26zMSGCh5K2mgMvIL96Z0HeS4DAaOytEcSn2zn7/5KhSjrPHTceqh8 
 26  p7dP90pZjMMjQ0PloRTZ6L2I2WPss2a4A+RLHp2vtSBeGr4KwIPRPuNzn8hDULGG/3njJDNT 
 27  nZpfmEi0su2IsEwTvqHFSs9kRlkBLt9xrYcDt8IlypVxaiWAbxqGMrH/Q6cQFytV9D0XBUqQ 
 28  B1Upvp8mEkS5kH2pUqDsBp+sDOUQVnau/sdxI3ADbjkvi+PbbcBlaPZ4FZ3ufSnrsBZJ2/ZR 
 29  DSB+XA+e+nNWH+3JBIYRX5pzuQ+AztK91vqRZRGxfo6CVcadF3HeLWV+dbuBredhskMzupjr 
 30  nzAR8Skin6eRvtic1a7J5g0RVFY7oOSxbx4B9QBY/ThFdoYpN8Iux5j+cKBiVYeaai8ZfUX4 
 31  g0hMMh4E1Rftn5yVc7lmEDEjii7qkw0kj9W/mOJcne9IZPyosWKuoVtBJaQw8ntx7bm4gSXw 
 32  Q/zLpx7oe1vhsac0JiVAgaeBb7E8HTMtvHmQlj6xmdpxlhg8igO6MmhllzIXp7Ta1cTonYpV 
 33  NrXUKwpQh4gaMVkIEl6EToVHUHoifyEkypYhQvTZEEke9GQWePmdbs1AwOuYr/yNbDyLtNEI 
 34  yRXVPhM9mjN4Ev5oUPAtf5Wbms0a1LSuyTFTXp+gCRD6/TDtIQwMZCO5576HTQjXMpPxcXIB 
 35  dxwRRfXL2tm6oYwAaYoIj1sOr6iedlNHniXikCAdVHiQyaGvEF9484/o4bRNOsg51VajMzvd 
 36  ujHU15EcPMGPBdNeZEzgsksEaFyRnGrLbWv638fRvX2NjKCeDj3TnXHLnqf8nPPDwSWWldiB 
 37  EeJe7kHzVF7Z8WdO7z2kpU+WCAfZeM6GQwcotXOwbcQwElICx89Tz/hVqmKYvL7blT09Q8Uu 
 38  aIjACxADWGjNcJ29GkKIFV3rZQooeDDCw6hi1Wpqw+NsFTH2RgVJ+KTmu+loFhanMc2a3int 
 39  /S3ZIDcf/pGLwla3zqIrAAUaz0x+ilog4Yphx5NYO5eNO10IDU0IjylwoOt5jNsuzrpFPTHC 
 40  jIUbz8Sr0Z1WPuojaCtSTNjuyv1x9lM6vDwgpH6hwFSSkpNQ6SzNSGDN8P+gRqa+MekyA3rT 
 41  K9ZElrG8QLLpCZh9ijJOwqy9ATAHIOQemvmLKQOzKmZ5HXNh4Ay/mTQ7JN+2LCintdqrze+b 
 42  38Zlxiw8ZRIDVmxiqCP2+u2gs5AGQwPP8j6jgMSgiFk5jLPwFpUomevoMWAZTPgcWUMvNCB9 
 43  I7+zuYIFXYN+E50dhnlTSFi5BwS4Tr9w1Nqe+aa33DxgpFWOEKaqulD5NDL+fpiW9h0gzUWk 
 44  5DN+/pVzwakQjEMZ91sMXFVD+CRD0OpD8Z0S/j2VPbghBMEfUjLeLZK/+hk7wcJxQ/Y2z9Ln 
 45  eNIkRouNsSHQCTqf0SM0JR5/HGubzfODYk2arEtjZwMzGAd8uT1qyr9bRzw9BYP+eEgyTF1+ 
 46  CvQS2UH2LM8jWkXkP/1IZADA2SFF9xB4ec3iIq1ZRShdsxJUuy2zCoGVEMdUNmQeJu7i4f4T 
 47  wDIyAlNkzHhD/EXOumzWYyg7b8DqZixxoYe6CCs8J8szHctELLmmcbBh9jrG61vmuFxoYMAK 
 48  4XriZMic58dX1HFDuA6N+qdCP+vE7QRoR6Dt/2Nb5ArbQqYOT9XHSBaYTrQWPJZOCD9GHlpF 
 49  0ODPDnIwS1POdf9k/5oAL4IH1e3RFMT8VXQZW1/OU317d/5b6fkodcbo0ph/0HmQYSrsvkIm 
 50  i95c8Tt6gX9II7itYb/bTKLB7U2EGVyM4sI9P7Yee+XE4mFJMUUFDW6dhQUziv6tBc09eiF3 
 51  vFEAyEtK/BIGewLOMVCH4nl6dCDPIrwIHR3PYvkglF0Kr/nzHRANYLUk9IFbsJsA7rxdukzf 
 52  AI5O9pYZw0LQTobzPxam2ETkdcqlMCDk8zdwecYy17iZdGH9u7/YvnkP/ce+m9niI1N4Dfgy 
 53  cCa/8RD7uBKUHMnkMe8MUY3I9j27rEeDCRMNELhBDH+0XMnZgRl19gOP2p6YcSYPaSksOY1I 
 54  ldm8L52yrgxFeXM0ifWCQRz59H40bCJ0URN3B0T+g2ixYX7Lv3AcRMB46SRfUlvVn3rtLVL+ 
 55  V4qYf//wMLSrQwc52xc3CJbwB0POmizTDFGE6qMg6fnQr/xPHojYc9kPz87sGXNSD30i7VJC 
 56  BXpmWfmb9ooSQJ27q/hkstsHXv//OiCKMBmeQXmBOoVTERwsb6pzMn1qJGAkiQw/Wkwjgqv5 
 57  RWfO3mVq0P29DHg0Rc64+QDizrbGaoaJzvOG7rzPCL6445q2KCr5DuNNCLBf9Kuqg01NCE9W 
 58  0QZyZnwGmmJlBlVVxnn+JZGf0fgsl7lAxhA4LQt7dG1MBRq0iJWEwMuKiXuD5Ln1qhF25PE9 
 59  IW4p6a6KrPD41xl5dHYr6QfDW0+x+apQS44w7+EzlyCn+HueuTavyRsTFrRSDQVPJEe5xKdq 
 60  904jvcvEQPigXzZF2jMlsMuBTwYpucFRLOXQreSkAfgSBYyAAM6b1WhUJp1HV9pE+eLVoO3L 
 61  mpg8gWfQWwraL6B2MnimDJO20Cjv7vhwFg802rVqQz1D/vuzF9T4PggpLfxzZxFFvemx1fW2 
 62  GEg4UJooTOzJ/a2qXNvkNvdSeGY/IkGdn4yEtUJ7h2uPmj0KqqO/P1DQsf6sfu0wmGf+VRur 
 63  EmEMRKKTSP4s8VaNm/6lZPZkcoGk47wyjI9IPLF/wgqi/pRdQJ/OiinrsNUMOwCXvodOkP0t 
 64  DFUhZIr6xZZOVRGD9Ew8IdbPCDMGHtC0NV0u1dhQtk4K2b/4+Ts6PKSWtbGVPZXoFw2fHp0T 
 65  K6O3LlLk7orkzUM9cIxTMbWkGSCfc6rxp4fEEwXAAC1exHIKEwLLLu302K2Uv8LBVMb8YhO7 
 66  uw8x0wAxQjrwEtNxiVna8XNMstDAzvBtOwb2NHglsK7W+o/rsAVgTN+Gc0+WUgj5Htn+LGT/ 
 67  nb5xzGK3d/spJ0ixefgpSOB9hj0T/poZMZOv7+bBo9mYv75VgjpyGU4I7dpOqqRp2Ek6tq/b 
 68  g547vgOqvikwn1MuToYOlbPBjwYrwfnqkKROA3J/JPi6qS4DmTvNEHoMtKUD0bFD8Vkrr5JO 
 69  +26MuuPHNvj5E7qEeUeft7kxkj/6cxqnHMjeU5CBMArkziMlfgxXjLOyQZNwD5zomZ9vZEJ/ 
 70  tN5lBJpn4lXXONBDqp9ttTHXswDXHV5M10uG9rmMCHkUdrWfAxoTAntxoSPp4g88VNq5KjH8 
 71  G2j28SpQPJTBQREQ/QXu12GqllN6RVuW0DxUm4r722iu9rIQukkidXPteLwQLNgcIjJSAN0j 
 72  k6cK/fj2+BnEe8SQBvvXuaaPmhzsTwAnD05k+30XBRDYW3CSbapwdbxq5JXBdbspXQ98+QcL 
 73  5EC567DWuml4qsSnBhsFH7XIJu4HpapSbbVtxrBv+UmuYv1W5ODwAiTr5BWdXZz4TtkfKE 
 74  /

- Migrated Bank, Dump is the same version of the bank which received the IMPD.

[diegolenhardt]

It's wrapped, I think you should look for the site I said, and do the unwrapped of the body,

and then try to compile, there will accuse the exact line of error,
I think it can be a missing table, a grant, etc
I think when it's wrap it will not show ..

[diegolenhardt]

I ended up finding a document that explains everything about wrapped

http://www.blackhat.com/presentations/b ... nnigan.pdf

very fera ..

]

BH-US-06-Finnigan.pdf

Wrap

(996.69 KiB) Downloaded 447 times