home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!gatech!concert!borg!hatteras!chia
- From: chia@hatteras.cs.unc.edu (Mr. Chia)
- Newsgroups: comp.databases.oracle
- Subject: SQL*FORM : execute_query and clear_block
- Message-ID: <14137@borg.cs.unc.edu>
- Date: 24 Jul 92 14:57:04 GMT
- Sender: news@cs.unc.edu
- Lines: 16
-
- Hi,
-
- I am trying to build a block such that the operator can only update or query
- about the table. He/She is not permitted to insert/delete a record.
-
- I grant select and update privileges to the operator. Then I tried
- execute_query; and clear_block('no_commit'); in the pre-block trigger.
- When I execute the form, I got the following message:
- execute_query; : illegal restricted procedure
- clear_block : unhandled exception: VALUE_ERROR
-
- What is wrong?
- Thanks.
-
- Wei-Jiun
-
-