Home » SQL & PL/SQL » SQL & PL/SQL » Pls correct this simple stored procedure...need help..
Pls correct this simple stored procedure...need help.. [message #194072] Wed, 20 September 2006 13:06 Go to next message
bnath001
Messages: 10
Registered: September 2006
Junior Member
I wrote a simple stored procedure: I am trying to call this stored proc from c# and I have issues with the parameters. Is there any wrong with this stored procedure?

create or replace PROCEDURE ReconcileHardm(io_cursor IN OUT portfolios.cryst_rep.ref_cur_type) IS

BEGIN


-- Join the two temp tables and do the reconciliation
OPEN io_cursor FOR
SELECT FAS133.DEAL, HEDGES.HEDGE_DEAL, FAS133.MTC_MV, HEDGES.Instrument_MV, FAS133.HEDGE_MV, HEDGES.HEDGE_MV,
FAS133.MTC_CURRENT_PAR,HEDGES.INSTRUMENT_PAR FROM TEMP_FAS133_MAIN_COPY FAS133 INNER JOIN TEMP_HEDGES_MON_f HEDGES
ON FAS133.DEAL = HEDGES.HEDGE_DEAL
WHERE FAS133.HEDGE_MV<>HEDGES.HEDGE_MV OR FAS133.MTC_CURRENT_PAR<>HEDGES.INSTRUMENT_PAR
OR FAS133.MTC_MV <> HEDGES.Instrument_MV ORDER BY DEAL;



END ReconcileHardm;

thanks
nath

Re: Pls correct this simple stored procedure...need help.. [message #194081 is a reply to message #194072] Wed, 20 September 2006 13:54 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
I don't see anything wrong with the proc. The same suggestions I provided before still apply (parameter does not need to be IN OUT - just OUT; use built-in sys_refcursor).

What error message are you getting? "Have issues" doesn't tell us anything useful.

[Updated on: Wed, 20 September 2006 13:55]

Report message to a moderator

Previous Topic: Quick question about statistics
Next Topic: Procedure with optional arguement
Goto Forum:
  


Current Time: Sat Dec 10 20:21:03 CST 2016

Total time taken to generate the page: 0.27357 seconds