Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Basic SQL and package question

Basic SQL and package question

From: Guy <guhar1_at_yahoo.com>
Date: Wed, 19 Dec 2007 13:23:50 -0800 (PST)
Message-ID: <d9fcd82e-01d7-4374-9be4-b9af0699af04@s19g2000prg.googlegroups.com>


I have package procedure which returns 1 if a code is valid. Si I try: SELECT
  A,
  B,
  PACKAGE_1.PROC_1(A.CODE) AS CODE_PERMISSION FROM
  TABLE
WHERE
  CODE_PERMISSION = 1 This returns and error message: CODE_PERMISSION invalid identifier.

So I have to resort to:
SELECT
  A,
  B
FROM
  TABLE
WHERE
  PACKAGE_1.PROC_1(A.CODE) = 1 But I have been told that calling a procedure in the "where" clause was invalidating any index on this table, which is uge. Any solution to this ? Thanks. Received on Wed Dec 19 2007 - 15:23:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US