Strange ... I never use "EXECUTE" when I run a database procedure within a
block, and I never
have any trouble ...
Computer Sciences Corporation
Registered Office: 2100 East Grand Avenue, El Segundo California 90245, USA
Registered in USA No: C-489-59
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery.
NOTE: Regardless of content, this e-mail shall not operate to bind CSC to
any order or other contract unless pursuant to explicit written agreement
or government initiative expressly permitting the use of e-mail for such
purpose.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
"Gonzalez Jorge
"
<oracledba-ezmlms To
hield-x76749016.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc
02/29/2008 02:39 Subject
PM RE: Calling Oracle Procedure inside
UNIX script
I don't have left clear that that these making, if C_EMAN is a procedure,
the sentence should be :
EXECUTE C_EMAN($1);
-----Mensaje original-----
De: krishnakumar
[mailto:oracledba-ezmlmshield-x81639490.[Email address protected]
Enviado el: 29/02/08 15:24
Para: LazyDBA Discussion
Asunto: Calling Oracle Procedure inside UNIX script
Hello Experts
I am calling an oracle procedure inside the unix shell script . Below
is my code
sqlplus -s / <<manf
begin
C_EMAN($1);
end;
/
show errors;
exit;
manf
exit 0
When I run the script I am getting the below error , though Oracle
procedure status is Valid & I have granted the procedure to public.
ERROR at line 3:
ORA-06550: line 3, column 1:
PLS-00201: identifier 'C_EMAN' must be declared
ORA-06550: line 3, column 1:
PL/SQL: Statement ignored
No errors.
Please help me
Thanks
Krishna
The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contain proprietary, confidential or privileged information. If you are not
the intended recipient, you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately and destroy all copies of this
message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient
should
check this email and any attachments for the presence of viruses. The
company accepts no liability for any damage caused by any virus transmitted
by this email.
www.wipro.com
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
------------- El contenido del presente mensaje y sus adjuntos es privado,
estrictamente confidencial y exclusivo para su destinatario, pudiendo
contener información protegida por normas legales y de secreto
profesional. Bajo ninguna circunstancia su contenido puede ser transmitido
o revelado a terceros ni divulgado en forma alguna. En consecuencia de
haberlo recibido por error, solicitamos contactar al remitente y eliminarlo
de su sistema. ---------------
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page