The stored procedure open fairly well, the day before today right to view, edit, delete will quote this wrong, one by one to see another in the same way, the rest are normal, baidu for a long time didn't solve, strives for the great god teach ~ ~ really appreciate!

CodePudding user response:

A few years ago met once, feel is a bug, ignored him; Recompile once there are no more questions,

CodePudding user response:

May the day before you create a stored procedure is not in the current user, before you build the wrong place, you can check under which user, if there is no record that I didn't,
SELECT the OWNER, OBJECT_NAME FROM DBA_OBJECTS WHERE OBJECT_NAME=UPPER ('????? ')

CodePudding user response:

Recompile the also not line, compile error

Want to change it to open it, delete also does not exist,,

CodePudding user response:

The process from 16 years in May was built last year, has been the user's, timing task now is also run up, processing data is no problem, just want to change it to open it

CodePudding user response:

reference 4 floor qq_36467319 response:

the process from 16 years in May was built last year, has been in the user, timing task now is also run up, processing the data is no problem, just want to change it won't open

If the operation that may be a BUG, if you build with quotes, lead to there is trouble PLSQL,

CodePudding user response:

Was built before colleagues, not too clear, has been no problems, only recently the problem, with the other colleagues PLSQL is the same

CodePudding user response:

The process or a synonym for deleted, reconstruction,

CodePudding user response:

Process also delete not to drop, will delete does not exist

CodePudding user response:

refer to the eighth floor qq_36467319 response:

process also delete not to drop, will delete no

Delete the add double quotation marks try drop procedure "pro_name"

CodePudding user response:

 

The select object_name, object_id, created, the status from user_objects where upper (object_name)='SGDD_EM_DISP_KT_WORK' 

CodePudding user response: