Hi,
I have written a stored procedure in Oracle but dont know how to run the stored procedure.I want to see whether I am getting correct records or not. My stored procedure is:

CREATE OR REPLACE PROCEDURE test(tcode in varchar)
AS
    typeCode varchar(2);
    status varchar(1);
BEGIN
   SELECT TYPE_CODE,ASSET_STATUS INTO typeCode,status FROM cas_assets WHERE TYPE_CODE = tcode;
END;


Please reply me how to see the result from the stored procedure.

Thanks and regards
Lily

CREATE OR REPLACE PROCEDURE test(tcode in varchar)
AS
    typeCode varchar(2);
    status varchar(1);
BEGIN
   SELECT TYPE_CODE,ASSET_STATUS INTO typeCode,status FROM cas_assets WHERE TYPE_CODE = tcode;

/*
For debugging purposes only
Run "Set ServerOutput On" statement, to get the result on to the iSql window, before calling the procedure.
*/

DBMS_OUTPUT.PUT_LINE (typeCode);
DBMS_OUTPUT.PUT_LINE (status);

END;

run procedure as follows

exec test('your argument');

Forgive me if I state the obvious, but before executing your stored procedure you'll first have to "store" it. Let's say you've got the TEST code in your PC's C:\TEMP directory, as TEST.SQL Via SQL*Plus: @C:\TEMP\TEST.SQL Then, again via SQL*Plus: / You'll get a PROCEDURE CREATED response. Then you'll be able to execute the procedure just as vijaykpit has mentioned.