OraFAQ Forum: Windows » calling stored procedure with input and output parameters from batch file

Home » Infrastructure » Windows » calling stored procedure with input and output parameters from batch file (Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

calling stored procedure with input and output parameters from batch file [message #525615]

Tue, 04 October 2011 02:34

MadanGeddada
Messages: 1
Registered: October 2011
Location: PUNE

Junior Member

when i am calling stored procedure with input and output parameters from batch file .. I am getting the following message ..

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Oct 4 11:48:51 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

14

=====================================

code which i have written ...

DEClARE
RETCODE NUMBER;
RETMSG VARCHAR2(200);

EXEC SP_SELCT_EMPLOYEE_DATA(277080,'EMPNAME ','EMAIL@EMAIL.COM', 9028045686,111333,25000,'PUNE',35,RETCODE ,RETMSG );

EXIT
================================================

Could you please help me out here

Thanks in adavance.

Madan

Procedure Name :

PROCEDURE SP_SELCT_EMPLOYEE_DATA (
-- A_EMPLOYEE_ID IN VARCHAR2,
--A_JOB_ID IN EMPLOYEES.JOB_ID%TYPE,
P_EMPLOYEE_ID IN EMPLOYEES.EMPLOYEE_ID%TYPE,
P_EMPLOYEE_NAME IN EMPLOYEES.EMPLOYEE_NAME%TYPE,
P_EMAIL IN EMPLOYEES.EMAIL%TYPE,
P_PHONE_NUMBER IN EMPLOYEES.PHONE_NUMBE%TYPE,
P_JOB_ID IN EMPLOYEES.JOB_ID%TYPE,
P_SALARY IN EMPLOYEES.SALARY%TYPE,
P_ADDRESS IN EMPLOYEES.ADDRESS%TYPE,
P_AGE IN EMPLOYEES.AGE%TYPE,
-- P_EMP_REFCUR OUT SYS_REFCURSOR, updated on 10/04/2011
RETCODE OUT NUMBER,
RETMSG OUT VARCHAR2)

[Updated on: Tue, 04 October 2011 02:40] by Moderator

Report message to a moderator

Re: calling stored procedure with input and output parameters from batch file [message #525621 is a reply to message #525615]

Tue, 04 October 2011 02:40

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And the problem is?

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

Report message to a moderator

Re: calling stored procedure with input and output parameters from batch file [message #525624 is a reply to message #525615]

Tue, 04 October 2011 03:01

flyboy
Messages: 1903
Registered: November 2006

Senior Member

MadanGeddada wrote on Tue, 04 October 2011 09:34

Could you please help me out here

Do not mix PL/SQL (DECLARE, by the way, BEGIN END part is missing) and SQL*Plus (EXEC) code. SQL*Plus has the ability to treat (bind) variables itself.

Study SQL*Plus Guide and Reference book, which is available with other Oracle documentation e.g. online on http://tahiti.oracle.com/
Concentrate on VARIABLE command and its usage examples.

Maybe these links may be useful too:
http://www.adp-gmbh.ch/ora/sqlplus/use_vars.html
http://www.dbforums.com/oracle/898216-how-run-function-procedure-sqlplus.html#post6436395

Report message to a moderator

Previous Topic:	Scheduled Removing of Trm and Trn files from Dump Area
Next Topic:	ROW-00001: Cannot allocate memory

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 20 19:38:27 CST 2025