Re: Urgent --> Calling function from a select statement in which the

Derek,

Lookup 'PRAGMA' statement in PL/SQL Docs (unfortunately, I don't have documentation around to provide exact syntax). Use PRAGMA (with appropriate parameters), when you create your function. This will assure Oracle, that you are not going to do 'Updates', and it will allow to use this function in SQL.
You don't have to use 'PRAGMA', when running 8i, because Oracle, itself checks, that there is no Updates/Inserts/Deletes in your function, and if that's the case - it allows to use it in SQL statement.

Igor Neyman, DBA
Perceptron, Inc.

• Original Message ----- From: "Wasmund, Derek" <DWasmund_at_EFTIA.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Saturday, June 03, 2000 3:36 PM Subject: Urgent --> Calling function from a select statement in which the

> Hello, I am trying to call a function from within a select statement and I
> am receiving the message "Function function_name does not guarantee not to
> update database". The function contains dynamic sql, however there is no
> update code. This will work under version 8 (8i) but does not work under
> version 7(7.34). Unfortunately I need to rely on executing the function
from
> a select statement and of course is of an extermely urgent nature. Does
> anyone have any ideas?
>
> Thanks!
>
> Derek
> --
> Author: Wasmund, Derek
> INET: DWasmund_at_EFTIA.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Sat Jun 03 2000 - 15:10:12 CDT