Title: Message
-Original Message-From: Niall Litchfield
[mailto:[EMAIL PROTECTED] Sent: 13 January 2004
11:16To: '[EMAIL PROTECTED]'Subject: RE: problems
with dbms_sql w/ 9.2.0.4???
There is a bug 3140063which at first glance looks as if it might be relevant to
you
-LSubject: FW: problems with
dbms_sql w/ 9.2.0.4???
-Original Message-From: Niall
Litchfield [mailto:[EMAIL PROTECTED] Sent: 13
January 2004 11:16To: '[EMAIL PROTECTED]'Subject:
RE: problems with dbms_sql w/ 9.2.0.4???
There is a bug 3140063which at first
Title: Yep.it's a Monday..
Developer is saying functions are good - all functions referencing
dbms_sql bomb???
Help???
problem with dbms_sql
Compiling function FUN_CHANGE_PASSWORD...
Compilation error on function FUN_CHANGE_PASSWORD:
PL/SQL ERROR 801 at line 1, column 1
Title: DBMS_SQL
Dear All,
I am trying to pass to dbms_sql.parse dynamic values from a cursor declared before the call by the dbms_sql.parse. I am getting ORA 1001 .
How can I do that?
Kind Regards,
Hatzistavrou Yannis
Title: DBMS_SQL
Would you mind to post a sample of your code?
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Hatzistavrou John
To: Multiple recipients of list ORACLE-L
Sent: Thursday, February 13, 2003 5:06
AM
Subject: DBMS_SQL
Dear
dear list,
i am inserting 90 million rows into a table using a
stored procedure. i have a rough estimate of space
16270M. i dont want to add datafiles to this
tablespace since i dont do any more inserts after
this.
i created an intial of 250M and next of 250M
after grabbing 62 extents it could
Title: RE: dbms_sql from stored procedure
Sarath,
Go locally managed tablespace and forget about extent management. It's just not worth it.
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
-Original Message
-
From: CHAN Chor Ling Catherine (CSC)
Sent: Thursday, October 17, 2002 4:12 PM
To: '[EMAIL PROTECTED]'
Subject:How to get the count of all tables using
dbms_sql
Hi,
I need to insert
Hi,
I need to insert the total number of records all the tables into the table,
MIGRATION_TABLE. I want to use the
How do I obtain the count(*) into a variable in dbms_sql.parse(cid, 'SELECT
COUNT(*) FROM ' ||i.owner||'.'||i.table_name, dbms_sql.v7); ?
TIA
Declare
cid INTEGER;
BEGIN
;
/
Regds,
New Bee
-Original Message-
From: CHAN Chor Ling Catherine (CSC)
Sent: Thursday, October 17, 2002 4:12 PM
To: '[EMAIL PROTECTED]'
Subject:How to get the count of all tables using
dbms_sql
CHAN Chor Ling Catherine (CSC) wrote:
Hi,
I need to insert the total number of records all the tables into the table,
MIGRATION_TABLE. I want to use the
How do I obtain the count(*) into a variable in dbms_sql.parse(cid, 'SELECT
COUNT(*) FROM ' ||i.owner||'.'||i.table_name, dbms_sql.v7);
the count of all tables using dbms_sql
Hi,
I need to insert the total number of records all the tables
into the table,
MIGRATION_TABLE. I want to use the
How do I obtain the count(*) into a variable in
dbms_sql.parse(cid, 'SELECT
COUNT(*) FROM ' ||i.owner||'.'||i.table_name, dbms_sql.v7
-Original Message-
Sent: Wednesday, 31 October 2001 11:25
There is a Procedure that uses DBMS_SQL that is causing some problems.
Basically I am having problems debugging it. I got it
down to the parse statement but see nothing wrong. I have taken the SQL
statement out of this code and ran
, 31 October 2001 11:25
There is a Procedure that uses DBMS_SQL that is causing some problems.
Basically I am having problems debugging it. I got it
down to the parse statement but see nothing wrong. I have taken the SQL
statement out of this code and ran it manually and it works so I don't
: Problem with DBMS_SQL - Long and probably annoying
There is a Procedure that uses DBMS_SQL that is causing some problems.
Basically I am having problems debugging it. I got it
down to the parse statement but see nothing wrong. I have taken the SQL
statement out of this code and ran
as to why the original developer used DBMS_SQL instead
of just using a cursor. Some people like to do things the hard
way I guess. This gets us over the hump until I get time to redo it.
-Original Message-
Sent: Wednesday, October 31, 2001 6:34 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED
There is a Procedure that uses DBMS_SQL that is causing some problems.
Basically I am having problems debugging it. I got it
down to the parse statement but see nothing wrong. I have taken the SQL
statement out of this code and ran it manually and it works so I don't
understand the error
first thing I'd do is to look at line 200 through 210 from user_source to
locate the problem. Also I'd put the sql statement as constructed using
dbms_output 9you'll have to do multiple calls as your sql might be 225
characters).
Running this SQL in sqlplus usually solves the invalid column
if it works.
HTH,
Bruce Reardon
-Original Message-
Sent: Wednesday, 31 October 2001 11:25
There is a Procedure that uses DBMS_SQL that is causing some problems.
Basically I am having problems debugging it. I got it
down to the parse statement but see nothing wrong. I have taken the SQL
view granted by sys
create any view granted by sys
execute on dbms_sql and dbms_sys_sql granted by sys
Nothing works.
HELP.- Any suggestions on where to go now ??
Thanks
Kevin
-Original Message-
Sent: Friday, September 21, 2001 2:17 PM
To: Multiple recipients of list
on dbms_sql and dbms_sys_sql granted by
sys
Nothing works.
HELP.- Any suggestions on where to go now
??
Thanks
Kevin
-Original Message-
Sent: Friday, September 21, 2001 2:17 PM
To: Multiple recipients of list ORACLE-L
How are your permissions
execute on dbms_sql and dbms_sys_sql granted by
sys
Nothing works.
HELP.- Any suggestions on where to go now
??
Thanks
Kevin
-Original Message-
Sent: Friday, September 21, 2001 2:17 PM
To: Multiple recipients of list ORACLE-L
How are your permissions
the procedure and it will create the view.
On the TEST instance RRS gets the error of Insufficient privileges .
I thought maybe it was that RRS could not run the DBMS_SQL routines so I
granted execute directly from sys to RRS on those. No dice.
I am STUMPED at this point.
Kevin
-Original
Title: RE: DBMS_SQL to Create views
Hi Kevin, this is kind of changing the topic... but why are you creating procedures as SYS?? Seems to me upgrades, patches, etc. would possibly endanger your procedure. I always thought of it as sys owning all the code that runs the database, data
granted select on the
tables to the ID RRS.
On the DEV instance RRS can run the procedure and it will create the view.
On the TEST instance RRS gets the error of Insufficient privileges .
I thought maybe it was that RRS could not run the DBMS_SQL routines so I
granted execute directly from sys
create any view granted by sys
execute on dbms_sql and dbms_sys_sql granted by sys
Nothing works.
HELP.- Any suggestions on where to go now ??
Thanks
Kevin
-Original Message-
Sent: Friday, September 21, 2001 2:17 PM
To: Multiple recipients of list ORACLE-L
Title: RE: DBMS_SQL to Create views
I am
creating a package owned by PCM$ but compiling it by SYS. I
thought that by compiling it by SYS the users running it would have all the
authority they needed to Create the views that the package
creates.
-Original Message-From: Koivu, Lisa
Dear All
Every time when I try to create table with the DBMS_SQL I get error
---
ORA-01031: insufficient privileges
ORA-06512: at SYS.DBMS_SYS_SQL, line 782
ORA-06512: at SYS.DBMS_SQL, line 32
ORA-06512: at DL.SP_CR, line 6
ORA-06512: at line 2
---
The procedure code is trivial
-Original Message-
Sent: 31 August 2001 13:01
To: Multiple recipients of list ORACLE-L
Dear All
Every time when I try to create table with the DBMS_SQL I get error
---
ORA-01031: insufficient privileges
ORA-06512: at SYS.DBMS_SYS_SQL, line 782
ORA-06512: at SYS.DBMS_SQL, line 32
ORA
: 31 August 2001 13:01
To: Multiple recipients of list ORACLE-L
Dear All
Every time when I try to create table with the DBMS_SQL I get error
---
ORA-01031: insufficient privileges
ORA-06512: at SYS.DBMS_SYS_SQL, line 782
ORA-06512: at SYS.DBMS_SQL, line 32
ORA-06512: at DL.SP_CR, line 6
privs in procedures gotten thru roles dont work, its not supposed to.
get create table privilege granted explicitly to yourself and it will
work.
joe
Dmitriy M. Labutin wrote:
Dear All
Every time when I try to create table with the DBMS_SQL I get error
---
ORA-01031
granted explicitly to yourself and it will
work.
joe
Dmitriy M. Labutin wrote:
Dear All
Every time when I try to create table with the DBMS_SQL I get error
---
ORA-01031: insufficient privileges
ORA-06512: at SYS.DBMS_SYS_SQL, line 782
ORA-06512: at SYS.DBMS_SQL, line 32
ORA-06512
]
Dmitriy_Labutin@epcc:
.minsk.by Subject: Problem with DBMS_SQL
Sent
The problem is not in dbms_sql. You must grant create
table privilege to the user even if it heritages from
a role.
Regards.
--- Dmitriy M. Labutin [EMAIL PROTECTED]
wrote:
Dear All
Every time when I try to create table with the
DBMS_SQL I get error
---
ORA-01031: insufficient
August 2001 13:01
To: Multiple recipients of list ORACLE-L
Dear All
Every time when I try to create table with the DBMS_SQL I get error
---
ORA-01031: insufficient privileges
ORA-06512: at SYS.DBMS_SYS_SQL, line 782
ORA-06512: at SYS.DBMS_SQL, line 32
ORA-06512: at DL.SP_CR, line 6
ORA
Hi,
I found this in metalink. I was able to duplicate your problem and even
though I have DBA role, I could not execut ethe proc until i granted myself
'create table' directly.
If a user is trying to create a table using DBMS_SQL, the user must have
create table privilege granted directly
:
.minsk.by Subject: Problem with
DBMS_SQL
Sent by:
[EMAIL PROTECTED]
2001.08.31 14:00
Please respond to
ORACLE-L
of dbms_sql (I want to
say it's dbms_sql.execute()). Either that or use EXECUTE IMMEDIATE.
Lisa Koivu
Oracle Database Administrator
954-935-4117
The information in the electronic mail message is Cendant confidential and
may be legally privileged, it is intended solely for the addressee(s
Title: RE: what's wrong with this...DBMS_SQL
DBAs
I have tried to pin package into memory and I got
those message. what means for pls-00201 error here.
Mitchel
execute dbms_shared_pool.keep('SYS.STANDARD');
BEGIN dbms_shared_pool.keep('SYS.STANDARD');
END;
*ERROR at line
1:ORA-06550
Mitchel,
I think you need to run dbmspool.sql under $ORACLE_HOME/rdbms/admin as sys
to create this package first.
HTH
Prakash
-Original Message-
Sent: Wednesday, June 13, 2001 12:32 PM
To: Multiple recipients of list ORACLE-L
DBAs
I have tried to pin package into memory and I got
Title: RE: what's wrong with this...DBMS_SQL
Lisa,
You don't need DBMS_SQL.EXECUTE, when running other then DML
statements. DBMS_SQL.PARSE is enough.
Igor Neyman, OCP DBAPerceptron, Inc.(734)414-4627[EMAIL PROTECTED]
- Original Message -
From:
Koivu, Lisa
To: Multiple
Title: RE: what's wrong with this...DBMS_SQL
Parse
doesn't execute DDL in oracle 7. The parse call uses 'dbms_sql.v7' so I
would guess that even if the d/b is 8 it will use the 7
semantics.
Regards
David
Lord
-Original Message-From: Igor Neyman
[mailto:[EMAIL PROTECTED]]Sent
is executed with execute.
-- DO NOT RELY ON THE CURRENT TIMING OF THE ACTUAL PARSING!
Joe
From: Koivu, Lisa [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: what's wrong with this...DBMS_SQL
Date: Tue, 12 Jun 2001 06:46:38 -0800
Thanks to Lisa and others who replied.
I cannot use EXECUTE IMMEDIATE as my Oracle version is 7.2.2.That is the
reason I am using DBMS_SQL.
At the beginning, I used DBMS_SQL.EXECUTE(CUR1), it gave errors, hence I
dropped.
Now I have used it again after your suggestion and noticed the error
of dbms_sql (I
want to say it's dbms_sql.execute()). Either that or use EXECUTE IMMEDIATE.
Lisa Koivu
Oracle Database Administrator
954-935-4117
The information in the electronic mail message is Cendant
confidential and may be legally privileged, it is intended solely
Title: RE: what's wrong with this...DBMS_SQL
Did you try it?
Iam not sure about v7.
But under 8.1.5 it works.
And why 'parse' should necessarily use 'dbms_sql.v7' ?
Here is an example, which proves, that for DDLit's
enough to call 'parse' without 'execute':
SQLWKS declare cur1 integer;
2
OF THE ACTUAL PARSING!
Joe
From: Koivu, Lisa [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: what's wrong with this...DBMS_SQL
Date: Tue, 12 Jun 2001 06:46:38 -0800
MIME-Version: 1.0
Received: from [209.68.248.164] by hotmail.com
On Tuesday 12 June 2001 06:31, Igor Neyman wrote:
RE: what's wrong with this...DBMS_SQLLisa,
You don't need DBMS_SQL.EXECUTE, when running other then DML statements.
DBMS_SQL.PARSE is enough.
Oracle has stated that even though DBMS_SQL.PARSE is currently sufficient
for non DML statements,
is not forcing a log
switch.
FYI, I want to track the sequence# of logfiles before and after the hot
backup, so that
I can backup the files in that range.
Am I properly using the DBMS_SQL?
Any help is highly appreciated
TIA,
Suren
Oracle DBA
Sony
--
Please see the official ORACLE-L FAQ: http
Title: RE: what's wrong with this...DBMS_SQL
Surendra, you need to execute it. Look at the spec of dbms_sql (I want to say it's dbms_sql.execute()). Either that or use EXECUTE IMMEDIATE.
Lisa Koivu
Oracle Database Administrator
954-935-4117
The information in the electronic mail message
The DBMS_SQL is executed inside a package, so the owner of the package must
be granted the ability to switch log files directly. More than likely, he
only has this privilege through a role.
Brian Norrell
Manager, MPI Development
QuadraMed
511 E John Carpenter Frwy, Su 500
Irving, TX 75062
(972
Hi Gurus,
I am experincing a problem with a procedure containing DBMS_SQL to create a
table.
On execution of the script I get the message PL/SQL procedure successfully
completed, but the table doesn't get created. In the error log file I can
see ORA-01031: insufficient privileges message. Any
, 18 April 2001 19:14
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Hi Gurus,
I am experincing a problem with a procedure containing DBMS_SQL to create a
table.
On execution of the script I get the message PL/SQL procedure successfully
completed, but the table doesn't get created. In the error log
, 2001 7:01 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Problem with DBMS_SQL
Hi Bhat,
The CREATE TABLE privilege probably needs to be granted
directly.
@ Regards,
@ Steve
Hi
If you can create the table in pure sql, then I maybe you don't have the
execute privielge for dbms_sql package.
Remember you must have this privilege explicitly granted to user not by a
role.
I hope this helps.
Gyula
see ORA-01031: insufficient privileges message. Any ideas.
create
Subject:RE: Problem with DBMS_SQL
Hi Bhat,
The CREATE TABLE privilege probably needs to be granted
directly.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http
Hi Steve/Dick,
Thanks for your clarifications. You are right. I was relying on the grant
via role and once I granted the privilege directly it worked fine.
Regards,
- Bhat
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City
57 matches
Mail list logo