Re: fuctions and DBMS_SQL package

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sun, 31 Jan 1999 16:56:14 GMT
Message-ID: <36b68aee.3589090@192.86.155.100>

A copy of this was sent to "gocham" <gocham_at_mci2000.com> (if that email address didn't require changing) On Sun, 31 Jan 1999 13:41:05 GMT, you wrote:

>Hi,
>
>Whenever I try to use DBMS_SQL package within a function I'm getting error
>on functon execution
>ORA-06571:
>Finction doesn't guarantee not to update database
>
>Am I doing something wrong?
>

no, its just that until Oracle8i, you cannot execute dynamic sql in a function called from SQL. The dbms_sql package does not guarantee to update the database and in Oracle8 and less, that is a requirement for a function called from sql.

Until 8i, you simply cannot do dynamic sql in plsql that is called from SQL.

>Thanks
>
>Gocha
>
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sun Jan 31 1999 - 10:56:14 CST