OraFAQ Forum: Server Administration » How to call userdefined func from a sql

Home » RDBMS Server » Server Administration » How to call userdefined func from a sql

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to call userdefined func from a sql [message #369721]

Fri, 25 August 2000 10:39

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????

Report message to a moderator

Re: How to call userdefined func from a sql [message #369723 is a reply to message #369721]

Fri, 25 August 2000 16:48

Lee
Messages: 56
Registered: May 1999

Member

Try

select name
from name_tab
where is_alpha(name) = 'TRUE';

Report message to a moderator

Re: How to call userdefined func from a sql [message #369731 is a reply to message #369721]

Fri, 01 September 2000 11:07

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.

Report message to a moderator

Previous Topic:	date datatype drive me crazYYY
Next Topic:	reg query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 01:20:19 CST 2025