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. ---------------
Oracle LazyDBA home page