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: 20891
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: summarize function decode
Next Topic: Error with inner select statement
Goto Forum:
  


Current Time: Sun Dec 04 02:18:35 CST 2016

Total time taken to generate the page: 0.12065 seconds