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: 299
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

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: 20052
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: 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>'

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 03 02:05:19 CST 2015

Total time taken to generate the page: 0.06551 seconds