You need to setup a PL-SQL Block to hold the variable returned from the
procedure call.

Example follows :

DECLARE
status_code NUMBER;
in_str VARCHAR2(32) := 'PassTest';
out_str VARCHAR2(32);


BEGIN
fast_md5.md5_hash(status_code,in_str, out_str);
--
dbms_output.put_line('.');
dbms_output.put_line('status_code = ' || to_char(status_code));
dbms_output.put_line('In String = ' || in_str);
dbms_output.put_line('Out String = ' || out_str);
dbms_output.put_line('.');
--
END;



-----Original Message-----
From: Baba Pratap Kumar
[mailto:oracledba-ezmlmshield-x24454222.[Email address protected]
Sent: Friday, February 25, 2005 9:46 AM
To: LazyDBA Discussion
Subject: Executing Oracle Stored Procedure


Hi All,



I need to execute a stored prodedure,



Could you guys help me in executing the same?



I was trying the command



exec
first2file.sps_sea_documentsearch_pkg.sps_sea_documentsearch(in1,in2,in3,in4
,in5,in6,in7,in8,in9,in10,in11,in12,in13,out1);





-Baba



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page