Select sysdate from dual into variable or rebluid the procedure to have in
variable and give the date in the execute command of the procedure.
-Mensagem original-
De: Malik, Fawzia [mailto:[EMAIL PROTECTED]
Enviada: quinta-feira, 2 de Outubro de 2003 12:50
Para: Multiple recipients of
Here's one way:
define delete_date_format = 'dd/mm/yy'
col old_nls_date_format noprint new_value old_nls_date_format
select value old_nls_date_format
from nls_session_parameters
where parameter = 'NLS_DATE_FORMAT'
/
alter session set nls_date_format = 'delete_date_format';
accept delete_date
bryan!
please provide the errors, you can query them with
SHO[W] ERR[ORS] ...
daniel
Bryan, Miriam wrote:
Hi List, I'm hoping someone can help me. I'm trying to compile a procedure,
which calls another procedure and I keep getting an error on the first end;
can't figure out what's
Title: RE: Help with procedure
There is a END IF missing before the EXCEPTION ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc
Miriam,
alaong with what everyone else sad, your loop control is wrong.
you said:
FOR x IN get_workgroups
this is not referencing your cursor properly. you named your cursor
get_admin.
the FOR statement should be:
FOR x in get_admin
hope this helps.
Tom Mercadante
Oracle Certified
Thanks to everyone that was gracious enough to take the time to look into my
procedure. IT WAS the ELSE IF statement, which I would've noticed it I
wouldn't have been in such a rush!
Thanks Again,
M. Bryan
-Original Message-
Sent: Monday, January 20, 2003 4:47 PM
To: Multiple
-
From: Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 7:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Help with procedure
There is a END IF missing before the EXCEPTION ...
Raj
Could you relate exactly what error you are seeing? Just seeing the code
doesn't help much...
To get the error messages, you can execute the following from SQL*Plus:
SHOW ERRORS PROCEDURE PROCEDURE CONVERT_AA_ADMIN
while connected as the account EMPLOYEE_ACTIVITY...
- Original Message
What is the exact error? What oracle version? Just guessing, are the privs
granted directly to the user or through a role? If they are via a role,
grant them directly to the user...
HTH
Tim
-Original Message-
Sent: Monday, January 20, 2003 4:16 PM
To: Multiple recipients of list