WHY can't I call a function from within a formula column???

From: John <john_at_austin.rr.com>
Date: Fri, 14 Dec 2001 15:16:31 GMT
Message-ID: <jJoS7.50546$zp5.2963778_at_typhoon.austin.rr.com>



Hello,
[Quoted] I am trying to modify pl/sql code behind a formula column (reports 2.5.7.17) and get this message when I try to compile: Function 'GETJOB' may not be used in SQL

The code for the formula column:
[Quoted] function CF_toolsFormula return Number is

v_var1 VARCHAR2(10);
begin
BEGIN
SELECT a.field1,
INTO v_var1
FROM table1 a,
table2 b
WHERE a.id = b.id
AND a.job = :job
[Quoted] AND rsi_attr.getjob(a.id, a.f1) = 1 ;
END;
END; [Quoted] The only line I added was the last line of WHERE clause (call to the function). Can you really not reference a function in a package from a formula column? I believe I did this with version 6. Is there a workaround to accomplish this in version 2?

Thanks in advance, Brad Received on Fri Dec 14 2001 - 16:16:31 CET

Original text of this message