SQL Language (MOSC)

MOSC Banner

unable to call function from a select statement

edited Mar 19, 2013 9:34AM in SQL Language (MOSC) 4 commentsAnswered
Hi,

I hope someone could help me figure out what's wrong with this.  I am trying to call a function via select statement (select function(param) from dual) and I am not getting an output on one of our server.  I have tried this on our devt environment and this is working fine.  I have also tried executing the function's script via anonymous block and I got an output from the server that wont initially produce the output.  Does anyone have an idea what's wrong with this?  Function is inside a package by the way and is owned by apps which is

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center