Answer for PL/SQL - PROBLEM

Hi all,

Remember my help call, that was a select what doesn't works in a storage procedure and works with in sqlplus. So, now i solve the problem, look what i did:

• I have a Oracle 8.0.4 in a Digital Unix and i was written my code with Procedure Builder in client station that uses Wnt WorkStatio. The caracterset of database is AMERICAN_AMERICA.US7ASCII and the NLS_LANG on my pc is "BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P2", well:
  1. I open a SP with procedure builder and made a cut and past to a notepad editor;
  2. dropped a procedure;
  3. run a export, on server;
  4. dropped the user;
  5. create the user again;
  6. import from a exported file;
  7. change the NLS_LANG according with the database;
  8. cut and paste again into de procedure builder;
  9. and finaly compile;

After all these steps it works. So, i did many things that would probably correct the problem, but only one have correct it.

Thank for all of you, that have thinked about it. Received on Wed Jul 19 2000 - 17:13:00 CDT