Home » Developer & Programmer » Forms » grant execution to a program unit in Forms (Oracle 10gR2, Windows XP)
grant execution to a program unit in Forms [message #406996] Mon, 08 June 2009 02:24 Go to next message
Roger22
Messages: 98
Registered: April 2009
Location: Brasov, ROMANIA
Member
Hello,

i have a program unit (procedure) named download_cv (in Forms), not a stored procedure in SQL Plus. however, when i sign in with a different user, when i press a button this procedure should be executed. with dba user signed in, i can execute it, but with the new user created, when the button is pressed, i got ORA-04067. Some people told me to grant execution on that procedure for that user, but the procedure is a program unit in Forms, not a SQL Plus procedure
Please help me.

Thanks!
Re: grant execution to a program unit in Forms [message #407011 is a reply to message #406996] Mon, 08 June 2009 03:02 Go to previous messageGo to next message
Littlefoot
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle
ORA-04067: not executed, string does not exist

Cause: Attempt to execute a non-existent stored procedure.

Action: Make sure that a correct name is given.


Perhaps you should consider moving the procedure out of the form and storing it into the database.
Re: grant execution to a program unit in Forms [message #407700 is a reply to message #406996] Thu, 11 June 2009 02:51 Go to previous message
nagu_bhat
Messages: 10
Registered: May 2009
Junior Member
Hi

Check the Grant on Tables used in the procedure to the new user. if grant is not given to the new user, then this error will rise.

Regards
Nagaraj
Previous Topic: Text Item
Next Topic: how to change Radio Button Visual Attribute ?
Goto Forum:
  


Current Time: Sat Aug 19 06:17:23 CDT 2017

Total time taken to generate the page: 0.01299 seconds