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
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
Igor
Oops, I stand corrected - works on 722, 734 & 816. Well, at least I've
learnt something today.
Regards
David Lord
-Original Message-
Sent: 12 June 2001 17:48
To: Multiple recipients of list ORACLE-L
Did you try it?
I am not sure about v7.
But under 8.1.5 it works.
And why 'par
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
ent) do not occur until the cursor 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 recip
Title: RE: what's wrong with this...DBMS_SQL
Did you try it?
I am 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 DDL it's
enough to call 'parse' wi
But using DBMS_SQL.EXECUTE only solved my problem,
Suren
-Original Message-
Sent: Tuesday, June 12, 2001 10:47 AM
To: Multiple recipients of list ORACLE-L
Thanks Igor for setting me straight. I don't see that in the doco but I am
looking at 8.1.7.
-Original Message---
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
cle
or 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
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
[mai
Title: RE: what's wrong with this...DBMS_SQL
Thanks Igor for setting me straight. I don't see that in the doco but I am looking at 8.1.7.
-Original Message-
From: Igor Neyman [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 9:31 AM
To: Multiple recipien
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,
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) 8
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 ma
Hi List,
As the part of developing hot backup strategy, I am testing the following
piece of code
to take care of arch files to be made avaialable along with backup set.
=
SQL> create or replace procedure log_switch as
2 cursor1 integer;
3 begin
4 cur1 := dbms_sql.ope
15 matches
Mail list logo
