Accessing Functions that are part of a Package

From: Ajay Mirmira <am359490_at_oak.cats.ohiou.edu>
Date: 2000/07/20
Message-ID: <39774f62.822462@news.cs.ohiou.edu>#1/1

I would like to know how to access functions that are part of a package. I have created a package pkg_functions and one of the functions in this package is called validate_date. This function validates a 8 digit number in the format yyyymmdd. When I created this function as a stand alone unit, it worked fine, but when it is part of the package, I get the following error:

ERROR at line 1:
ORA-06571: Function VALIDATE_DATE does not guarantee not to update database

The package specification and body compile with out any errors. I would be grateful if anybody can help me.

Ajay Mirmira
ORACLE Applications Programmer
Ohio University Received on Thu Jul 20 2000 - 00:00:00 CDT