odessp

Hi All,

I have created a procedure UPDATE_JC1 and I can see it by doing the the following SQL select in server manager:

  SVRMGR>select * from all_objects where object_type='PROCEDURE';

However, when I use OCI function odessp(), I got errors:

  ORA-20004: syntax error attempting to parse "UPDATE_JC1"
  ORA-06512: at "SYS.DBMS_DESCRIBE", line 57
  ORA-06512: at line 1
  ORA-04063: package body "SYS.DBMS_UTILITY" has errors
  ORA-06508: PL/SQL: could not find program unit being called

Did I miss anything here ?

Thanks for any pointers,

-- 
James Chen,	at Interweave Software, Inc.
james_at_iweave.com