Home » SQL & PL/SQL » SQL & PL/SQL » What are valid and invalid functions in PL-SQL (Oracle)
What are valid and invalid functions in PL-SQL [message #608073] Sat, 15 February 2014 00:56 Go to next message
jgjeetu
Messages: 240
Registered: July 2013
Location: India Delhi Rohini Sec-1
Senior Member

Please explain What are valid and invalid functions in
PL-SQL and how to correct invalid function to valid functions.
If possible provide examples too.
Thanks
Re: What are valid and invalid functions in PL-SQL [message #608077 is a reply to message #608073] Sat, 15 February 2014 01:21 Go to previous messageGo to next message
Littlefoot
Messages: 19815
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Invalid functions are the ones that aren't valid for some reason. When you run the CREATE (OR REPLACE) FUNCTION statement (SQL*Plus is a nice tool to do that), Oracle will report if it failed to create the function. SHOW ERRORS will tell you why it failed. Once you fix those errors, CREATE would create the function and make it valid.
Re: What are valid and invalid functions in PL-SQL [message #608142 is a reply to message #608077] Mon, 17 February 2014 00:18 Go to previous message
msol25
Messages: 234
Registered: June 2011
Location: Mumbai
Senior Member
hi,

If object is already existing in particular schema and you want check validity for that
object.Please use below mentioned query :


select  owner,object_name,object_type,status
from    dba_objects
where   owner = '<enter schema name>'

Previous Topic: Convert number to CHAR
Next Topic: FROM WHERE TO DOWNLOAD UTL_TCP, UTL_SMTP , UTL_MAIL PACKAGES
Goto Forum:
  


Current Time: Thu Nov 27 06:25:03 CST 2014

Total time taken to generate the page: 0.11887 seconds