OraFAQ Forum: SQL & PL/SQL » What are valid and invalid functions in PL-SQL

Home » SQL & PL/SQL » SQL & PL/SQL » What are valid and invalid functions in PL-SQL (Oracle)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

What are valid and invalid functions in PL-SQL [message #608073]

Sat, 15 February 2014 00:56

jgjeetu
Messages: 161
Registered: July 2013
Location: India

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

Report message to a moderator

Re: What are valid and invalid functions in PL-SQL [message #608077 is a reply to message #608073]

Sat, 15 February 2014 01:21

Littlefoot
Messages: 18648
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.

Report message to a moderator

Re: What are valid and invalid functions in PL-SQL [message #608142 is a reply to message #608077]

Mon, 17 February 2014 00:18

msol25
Messages: 293
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>'

Report message to a moderator

Previous Topic:	Convert number to CHAR
Next Topic:	Total Time.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Mar 07 03:17:18 CST 2014

Total time taken to generate the page: 0.17940 seconds