Re: HELP - PL/SQL using DBMS_SQL in Store Procedures doesn't work!

From: <madhus_at_aquas.com>
Date: 1997/07/29
Message-ID: <870138885.27055@dejanews.com>#1/1

My guess is that the tables: w_wellwork_common, w_selected_wellwork are not
owned by the user under which you are logging in and executing. If this is
the case, give select access on these tables directly to the user, not thru'
a role. Procedures require direct access. Try this and it should work. good luck!

Madhu S, DBA
madhus_at_aquas.com

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet

Received on Tue Jul 29 1997 - 00:00:00 CDT

This message: [ Message body ]
Next message: Tomm Carr: "Re: HELP - PL/SQL using DBMS_SQL in Store Procedures doesn't work!"
Previous message: Rashid KArimov: "Re: stored procedure recompile problem"
In reply to: Larry Jones: "HELP - PL/SQL using DBMS_SQL in Store Procedures doesn't work!"
Next in thread: Tomm Carr: "Re: HELP - PL/SQL using DBMS_SQL in Store Procedures doesn't work!"
Reply: Tomm Carr: "Re: HELP - PL/SQL using DBMS_SQL in Store Procedures doesn't work!"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US