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.
003 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
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
selec
iginal Message-
>>>From: 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
(B-Ursprungliche 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 t
Paul Vincent [mailto:[EMAIL PROTECTED]
>>>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 deve
;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
> >
> >
uest 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
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 by
nal 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 a
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,
>
ORACLE-L <[EMAIL PROTECTED]>
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
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
W
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
>
>
MMIT;
EXCEPTION
WHEN OTHERS 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 li
To: Multiple
> recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent by: cc:
> root@fatcity.Subject: Ang: Re:
> PL/SQL procedure - error
> com
>
>
> 01/22/
Sent by: cc:
root@fatcity.Subject: Ang: Re: PL/SQL procedure - error
com
01/22/2002
09:15 AM
Please
respond to
ORACLE-L
Thanks,
a
ct: Ang: Re: PL/SQL procedure -
error
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 r
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 v
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
=
"Hagedorn, 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:
Sub
> "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
Title: DDL alter in execute immediate pl/sql procedure - dynamic sql
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 impor
>
> 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)
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 ret
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
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 then
29 matches
Mail list logo