]
Sent: Tuesday, August 12, 2003 5:29 PM
To: Multiple recipients of list ORACLE-L
Subject: Referencing other schemas' tables in PL/SQL procedure
Hi,
one of our developers is having a problem. His userid has
the DBA role on a test database, and he's written a PL/SQL
procedure, in his schema, which
prungliche Nachricht-
(BVon: Naveen Nahata [mailto:[EMAIL PROTECTED]
(BGesendet: Dienstag, 12. August 2003 14:34
(BAn: Multiple recipients of list ORACLE-L
(BBetreff: RE: Referencing other schemas' tables in PL/SQL procedure
(B
(B
(BThere was a discussion on this list, regarding the same a few m
Hi,
one of our developers is having a problem. His userid has the DBA role on a test
database, and he's written a PL/SQL procedure, in his schema, which is referencing
(via SELECT) and updating a table in another schema, so he's coding the select as:
CURSOR c1
IS
select distinct
: Paul Vincent [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 12, 2003 5:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Referencing other schemas' tables in PL/SQL procedure
Naveen - many thanks! I had a vague recollection that this
may be the case, rattling around in the back of my
of list ORACLE-L
Subject: Referencing other schemas' tables in PL/SQL procedure
Hi,
one of our developers is having a problem. His userid has
the DBA role on a test database, and he's written a PL/SQL
procedure, in his schema, which is referencing (via SELECT)
and updating a table in another
Title: RE: Referencing other schemas' tables in PL/SQL procedure
story of usual suspects
culprit: SELECT privilege granted through role
Resolution: Grant SELECT privilege as schema owner TO the procedure owner directly.
Raj
Message --
Date: Tue, 13 Aug 2002 14:34:13 -0800
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
From: Danny Hughes [EMAIL PROTECTED]
Subject: nextval increments by 2 in pl/sql procedure
hello all,
I have a pl/sql procedure that selects the nextval from
for the
value from the sequence by any other session.
Naveen
-Original Message-
Sent: Wednesday, August 14, 2002 4:04 AM
To: Multiple recipients of list ORACLE-L
hello all,
I have a pl/sql procedure that selects the nextval from a sequence. The
problem is that it incrrements the sequence
the sequence by any other session.
Naveen
-Original Message-
Sent: Wednesday, August 14, 2002 4:04 AM
To: Multiple recipients of list ORACLE-L
hello all,
I have a pl/sql procedure that selects the nextval from a sequence. The
problem is that it incrrements the sequence by 2 in a pl
ORACLE-L [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
From: Danny Hughes [EMAIL PROTECTED]
Subject: nextval increments by 2 in pl/sql procedure
hello all,
I have a pl/sql procedure that selects the nextval from a sequence. The
problem is that it incrrements the sequence by 2 in a pl
hello all,
I have a pl/sql procedure that selects the nextval from a sequence. The problem is
that it incrrements the sequence by 2 in a pl/sql procedure. If I select the nextval
from a sqlplus session, it works fine.
here is partial code that I am using.
PROCEDURE NEWTRANSACTION
I apologize for my dirty post here, Roland.
I have had a bad day.
I'm sorry.
Jan Pruner
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: PL/SQL - procedure
Dear Roland,
first try to use your brain than ask
]
cc:
Subject:Re: PL/SQL - procedure
Dear Roland,
first try to use your brain than ask in this group.
Yesterday I've posted email about Exceptions in Oracle (to catch an error)
and the tip - don't use datatype DATE to store start/end time.
OK, the second
Hallo,
Can anyone give me an example on a pl/sql code, which does the following:
I have 4 procedures, and I want the following to be logged in a status
table.
Procedure names
Start_time of procedure
End_time_of procedure
Error_code(if anything goes wrong)
Error_message
Please give
Dear Roland,
first try to use your brain than ask in this group.
Yesterday I've posted email about Exceptions in Oracle (to catch an error)
and the tip - don't use datatype DATE to store start/end time.
OK, the second tip:
PROCEDURE my_procedure (
COMMIT;
RETURN;
EXCEPTION
@fatcity.Subject: Ang: Re:
PL/SQL procedure - error
com
01/22/2002
09:15 AM
Please
respond to
ORACLE-L
Thanks,
and can you please tell me how
THEN
ROLLBACK;
END;
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Thu, January 24, 2002 3:00 PM
To: Multiple recipients of list ORACLE-L
Subject: Ang: Re: Ang: Re: PL/SQL procedure
Hallo,
anyone who can help me with a pl/sql procedure that
I have four procedures that will run one after one:
in an error table logs the procedurename, the start time of the procedure and the end
time of the procedure.the number of rows inserted(there are insertstatements in the
procedures
hi Roland
Hope below code will help u,
BEGIN
p1;
p2;
p3;
p4;
COMMIT;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
END;
procedure p1
is
BEGIN
insert into aa values (1,'1');
END;
procedure p2
is
BEGIN
insert into aa values (2,'2');
END;
procedure p3
is
BEGIN
insert into aa
Thanks,
and can you please tell me how to get hold of the time when the procedures starts and
finishes.?
Thanks in advance.
Roland
Pullikol Kumar [EMAIL PROTECTED]@fatcity.com den 2002-01-22 04:40 PST
Sänd svar till [EMAIL PROTECTED]
Sänt av: [EMAIL PROTECTED]
Till: Multiple
, Linda [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
29/12/2001 05:55 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Fax to:
Subject:DDL alter in execute immediate pl/sql procedure - dynamic sql
If someone has a few
Hagedorn, Linda wrote:
If someone has a few minutes to read through this, I'd be most
appreciative. I could use a second set of eyes looking this over.
This procedure is designed to maintain a table/sequence map, executed
after an import and increment any sequences which have a lower
Dear DBAs !
I need to write a stored proc that will do the following :
-- open a cursor ;
-- loop over the rows returned by the cursor ,
filter out some of the rows that do not match a certain criteria ,
do some processing on other rows (that match the criteria)
Dear DBAs !
I need to write a stored proc that will do the following :
-- open a cursor ;
-- loop over the rows returned by the cursor ,
filter out some of the rows that do not match a certain criteria ,
do some processing on other rows (that match the criteria)
and
hi Andrew,
consider using a array (pl/sql table) as a return
datatype of your function. Inside the function open ur
cursor and populate that set of rows u wanna return
into the return datatype.. which would be an array in
this case. note that u must define a global array in
some package first so
Audrey:
What you want is a cursor variable. A cursor variable references a cursor
object and may refer to different SQL statements at different times. In your
case, the most important benefit of the cursor variable would be that it
provides a mechanism for passing results of queries (the rows
26 matches
Mail list logo
