Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Oracle ORA-24372 invalid object for describe workaround?
386 views
Skip to first unread message
louann
Jan 10, 2005, 3:02:42 PM1/10/05
to
I am executing an Oracle stored procedure from a command
button. If the procedure is invalid, I get the error
ORA-24372 invalid object for describe. However, if I
execute this procedure from a SQL prompt, Oracle recompiles
the procedure on the fly and it executes successfully. Is
there any way to force Oracle to recompile the procedure on
the fly from PowerBuilder?
button. If the procedure is invalid, I get the error
ORA-24372 invalid object for describe. However, if I
execute this procedure from a SQL prompt, Oracle recompiles
the procedure on the fly and it executes successfully. Is
there any way to force Oracle to recompile the procedure on
the fly from PowerBuilder?
PowerBuilder Version 9.0.1 Build 7151
Oracle9i Enterprise Edition Release 9.2.0.1.0
Terry Dykstra
Jan 10, 2005, 7:00:33 PM1/10/05
to
The user needs 'alter any procedure' privileges, which allows the user to
recompile but not modify the procedure.
recompile but not modify the procedure.
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://www.pb9books.com
product enhancement requests:
http://www.isug.com/cgi-bin/ISUG2/submit_enhancement
<louann> wrote in message news:41e2df5e.517...@sybase.com...
louann
Jan 11, 2005, 8:42:37 AM1/11/05
to
I granted the user the 'alter any procedure' privilege and
get the same results. If the same user executes the
procedure from a SQL prompt, Oracle will recompile it on the
fly transparent to the user.
get the same results. If the same user executes the
procedure from a SQL prompt, Oracle will recompile it on the
fly transparent to the user.
It looks like PowerBuilder tries to do a DESC on the
procedure before executing it, and since the object is
INVALID at the time, it returns the ORA-24372 error.
0 new messages