OraFAQ Forum: SQL & PL/SQL » URGENT PL/SQL IN SELECT STATEMENTS

Home » SQL & PL/SQL » SQL & PL/SQL » URGENT PL/SQL IN SELECT STATEMENTS

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

URGENT PL/SQL IN SELECT STATEMENTS [message #19898]

Wed, 17 April 2002 03:49

Anderson
Messages: 10
Registered: December 1999

Junior Member

I have written a function which takes one argument as below:
FUNCTION CHECKING (DPT_CODE VARCHAR2)RETURN VARCHAR2 is
DEPT VARCHAR2(4);

BEGIN
DEPT := :DPT_CODE;
if :DPT_CODE like 'C%'
then
return 'y';
else
return 'n';
end if;
END;
If I use this in the select statement as this select DPT_Code from tableName where Checking(DPT_Code) = 'y'
it doesnt work.

I get an error messege INVALID COLUMN NAME. CAN U PLEASE HELP. I HAVE PUT THIS UNDER THE PROGRAM UNITS IN REPORTS. PLEASE HELP

Report message to a moderator

Re: URGENT PL/SQL IN SELECT STATEMENTS [message #19903 is a reply to message #19898]

Wed, 17 April 2002 06:59

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

are u lookin for something like this?
-------------------------
create or replace FUNCTION CHECKING (DPT_CODE VARCHAR2)RETURN VARCHAR2 is
DEPT VARCHAR2(4);
BEGIN
DEPT := DPT_CODE;
if dept like 'C%'
then
return 'y';
else
return 'n';
end if;
END;
/

Report message to a moderator

Re: URGENT PL/SQL IN SELECT STATEMENTS [message #19905 is a reply to message #19903]

Wed, 17 April 2002 07:36

Anderson
Messages: 10
Registered: December 1999

Junior Member

Thanks it has worked now.

Report message to a moderator

Previous Topic:	& Literal String in PL/SQL
Next Topic:	Delete or Update, what is faster

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 22:03:59 CDT 2024