Webdb error: PLS-00302: component must be declared

I'm trying to use Oracle WebDB to design a form, but I keep getting an error that stops me from advancing...

According to the documentation, it should be possible to initialize a form with default values to fields by using functions stored in the database. I've created such a function, that returns a number. (A "nextval" from a sequence) I'm trying to put this function to use in a numeric field on the form. I put in the following text in the Default Value field in the "Edit form" form:

     #logg.get_loggid

"logg" is the schema owning the function, and "get_loggid" is the function, that returns a number. I've got execute permissions on this function, and I've tested it, and it works when I run it from the "Execute function" page in WebDB.

However, when I put it in my form as mentioned above, and try to compile the form by pressing the "finish" button, I get this error:

    PLS-00302: component 'GET_LOGGID' must be declared

What can possibly be wrong here?
Are there any other ways of initializing the fields to a "nextval" from a sequence?

--
Roar Pettersen
roarp_at_my-dejanews.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 08 1999 - 02:33:16 CDT