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 -> Re: problem calling pl/sql fn. from SQL

Re: problem calling pl/sql fn. from SQL

From: Grinberg L. <leon_at_grant.kharkov.ua>
Date: Sat, 24 Oct 1998 12:25:35 +0300
Message-ID: <70s5tb$8o8@grant.grant.UUCP>

Gopal wrote in message <363119CF.338C16BD_at_cisco.com>...
>I am failing to call a funtion which reads a pl/sql memory table
>with this error
>(1):PLS-00452: Subprogram violates its associates pragma
>
>code:
> if plsqlmemory_table.EXISTS (index) then
>

PL/SQL Table attributes (EXISTS, COUNT, FIRST, NEXT, LAST, PRIOR, DELETE) are functions from package SYS.PLITBLM. Unforttunately they havn't PRAGMA RESTRICT_REFERENCES in ORACLE 7.3, but have it in latest version. IMHO it's bug. Received on Sat Oct 24 1998 - 04:25:35 CDT

Original text of this message

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