Re: PL/SQL: DBMS_SQL Package...

On Thu, 19 Mar 1998 06:05:07 -0600, andreas.prusch_at_sintec.de wrote:

Hello,

You can also use the DBMS_SQL package within Forms 4.5. All you have to do is to substitute the last DBMS_SQL.V7 in the PARSE statement with the value 1.

If you can't compile the program unit within Forms 4.5 you have to grant rights to execute the package DBMS_SQL to the user/Public.

Greetings,

Robert.

>In article <351084C6.36AF_at_connico.net>,
> mrosadino_at_connico.net wrote:
>>
>> Hi:
>> I have a question regarding the DBMS_SQL package provided through the
>> Oracle 7 server; we have Oracle 7.3 currently installed on an HP-UX 3000
>> server and we've been experimenting with stored procedures which make
>> use of the DBMS_SQL package [which we call from an Oracle 4.5 Forms
>> app]. In our code, we are passing SQL DDL statements into the stored
>> procedure for execution & commit. It appears that the only way we can
>> successfully execute these procedures is if the stored procedure is
>> stored under the SYS owner. Does anyone know of a way to store the
>> procedure under a userspace while designing/debugging so that the code
>> could be executed successfully from the userspace without having to port
>> it to the SYS owner?
>> --
>> Michael Rosadino
>> E-mail(W): mrosadino_at_ggtinc.com
>> Work: (860)871-8082, x3484
>>
>
>You have to make grants for each ddL command you want to execute with
>DBMS_SQL. If you want to execute "CREATE TABLE.." with DBMS_SQL your previous
>job is to grant "create table" to the user of dbms_sql. This is because the
>privileges you get by roles have no implications on DBMS_SQL.
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Tue Mar 24 1998 - 00:00:00 CET