DECODE FUNCTION

[dshaw21369]

Hi,
Can you call a procedure when returning value using the DECODE function?

 

[SantaMufasa]

Dshaw,

I'm not certain what your question means, so if you can clarify, that would be helpful. I can tell you that PL/SQL does not support the DECODE function directly. If you want to use DECODE withing PL/SQL, it must be within a straight SQL statement within PL/SQL, otherwise you receive a pass-1 interpreter error.

I'm happy to share more if you can clarify your question.

Dave

 

[stefanhei]

You can use functions quite freely with DECODE. But performance is another chapter, especially when using aggregatefunctions like SUM,...

Stefan

 

[dshaw21369]

I guess I'm trying to ask, can you call a procedure from the DECODE function.

 

[BJCooperIT]

DECODE is a function used in an SQL statement. A DECODE cannot call a stored procedure; however, it can use another function as one or more of it's parameters. Example:

select decode(COL1,'X','Y',MY_FUNCTION(COL1))
from   MY_TABLE

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Consultant/Custom Forms & PL/SQL - Oracle 8.1.7 - Windows 2000

 

[dshaw21369]

Great thanks!