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: 359
Registered: July 2013
Location: Orafaq

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: 20825
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: 349
Registered: June 2011

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: Mon Sep 26 11:07:04 CDT 2016

Total time taken to generate the page: 0.14187 seconds