Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL
PL/SQL [message #245943] Tue, 19 June 2007 06:57 Go to next message
kr_arvind
Messages: 85
Registered: April 2006
Location: Delhi
Member
Hi All,

Please help how can execute give procedure with IN and OUT paramenters, when i run then below erros has been occured.

PROCEDURE
CREATE OR REPLACE PROCEDURE MML_MP_MANUAL_INPUT
(
MODELNO IN VARCHAR2,
MODELPAIRID IN number,--PRX.MML_MODEL_PAIR_DETAIL.MODEL_PAIR_SEQ_ID%TYPE,
DAC_CURRENT OUT VARCHAR2
-- ESTM_AVAIL OUT VARCHAR2,
-- ESTM_DROP OUT VARCHAR2,
-- COL_CODE OUT VARCHAR2,
-- BENCHMARK_CURRENT OUT VARCHAR2

)
IS
APPROVEDSTATUS PRX.MML_MODEL_PAIR_DETAIL.APPROVED_STATUS%TYPE; -- CAPTURES MODEL APPROVED STATUS

v_DAC_CUR varchar2(100);

BEGIN
dbms_output.put_line('asd');
END MML_MP_MANUAL_INPUT;


Process of Execution:


exec MML_MP_MANUAL_INPUT('a',2);


EROOR
wrong number or types of arguments in call to


please help for the same.



Thanks & Regards,
Arvind
Re: PL/SQL [message #245945 is a reply to message #245943] Tue, 19 June 2007 07:02 Go to previous messageGo to next message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
If you look carefully at the proc, you will see there are 3 parameters, not 2. The last is an output parameter, so you will have to return the value into another variable.
Re: PL/SQL [message #245952 is a reply to message #245945] Tue, 19 June 2007 07:16 Go to previous messageGo to next message
kr_arvind
Messages: 85
Registered: April 2006
Location: Delhi
Member
But IN parameter is 2, is it any way to ignore the OUT parameter when we are execute the given procedure. Please advise me
Re: PL/SQL [message #245955 is a reply to message #245943] Tue, 19 June 2007 07:18 Go to previous message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
Retrieve the value into a variable and don't bother looking at it...

Other than that, no.
Previous Topic: Loading all files from a directory into database table.
Next Topic: supplied Packages
Goto Forum:
  


Current Time: Thu Dec 08 08:50:46 CST 2016

Total time taken to generate the page: 0.12815 seconds