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)
calling stored procedure with input and output parameters from batch file [message #525615] Tue, 04 October 2011 02:34 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68055
Registered: March 2007
Location: Nanterre, France, http://...
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
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 Go to previous message
flyboy
Messages: 1899
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
Previous Topic: Scheduled Removing of Trm and Trn files from Dump Area
Next Topic: ROW-00001: Cannot allocate memory
Goto Forum:
  


Current Time: Wed Dec 08 16:31:33 CST 2021