Home » SQL & PL/SQL » SQL & PL/SQL » Create a function
Create a function [message #191042] Mon, 04 September 2006 04:45 Go to next message
Messages: 95
Registered: July 2003
Hello folks,

I've made a script in order to create a function. Once executed in the sqlplus utility, I receive the following error message :" Warning: procedure created with compilation error ".

Aside this the view USER_PROCEDURES does not display the name of my function.

What is the problem and what did I miss to achieve correctly my task?

.. Thankful for any help Smile
Re: Create a function [message #191045 is a reply to message #191042] Mon, 04 September 2006 04:49 Go to previous message
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
after creating the function, type

Show Err

or you can query the user_errors table.

This will show you the errors in your code.

You should read the documentation


Previous Topic: Storing value in a variable
Next Topic: Do I need a join?
Goto Forum:

Current Time: Sat Jul 29 07:07:00 CDT 2017

Total time taken to generate the page: 0.21550 seconds