OraFAQ Forum: Forms » grant execution to a program unit in Forms

Home » Developer & Programmer » Forms » grant execution to a program unit in Forms (Oracle 10gR2, Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

grant execution to a program unit in Forms [message #406996]

Mon, 08 June 2009 02:24

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!

Report message to a moderator

Re: grant execution to a program unit in Forms [message #407011 is a reply to message #406996]

Mon, 08 June 2009 03:02

Littlefoot
Messages: 21826
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.

Report message to a moderator

Re: grant execution to a program unit in Forms [message #407700 is a reply to message #406996]

Thu, 11 June 2009 02:51

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

Report message to a moderator

Previous Topic:	summarize function decode
Next Topic:	Error with inner select statement

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 17 09:02:22 CST 2025