Home » RDBMS Server » Server Administration » How to call userdefined func from a sql
How to call userdefined func from a sql [message #369721] Fri, 25 August 2000 10:39 Go to next message
golda
Messages: 1
Registered: August 2000
Junior Member
Hi,
I like to know how to call userdefined function from a sql statement which will be used in a cursor.The function returns boolean value after checking the parameter passed is alpha(true) or alphanumeric(false).
select name
from name_tab
where is_alpha(name); is this right????
Re: How to call userdefined func from a sql [message #369723 is a reply to message #369721] Fri, 25 August 2000 16:48 Go to previous messageGo to next message
Lee
Messages: 56
Registered: May 1999
Member
Try

select name
from name_tab
where is_alpha(name) = 'TRUE';
Re: How to call userdefined func from a sql [message #369731 is a reply to message #369721] Fri, 01 September 2000 11:07 Go to previous message
JOHN
Messages: 182
Registered: April 1998
Senior Member
Hmmm, unless my memory fails me, then functions called in SQL are only allowed to return basic Oracle variable types (ie Long, Varchar2, Date, Number, Char and a couple of others).
Booleans are a Pl/SQL data type, and aren't valid.
Previous Topic: date datatype drive me crazYYY
Next Topic: reg query
Goto Forum:
  


Current Time: Sat Oct 24 04:51:58 CDT 2020