Re: Simple Create Procedure Problem..

From: anal_aviator <analaviator_at_pornolizer.com>
Date: Thu, 2 Dec 2004 05:47:09 +0800
Message-ID: <0001HW.BDD45CDD00020054F03055B0@news.newsguy.com>

On Wed, 1 Dec 2004 17:34:40 +0800, Arijit Chatterjee wrote (in article <ea01504d.0412010134.65ddfb35_at_posting.google.com>):

> Respected Faculties,
> As per your instruction at last I have created the procedure.But I
> want to see the output in variable "Open_Bal".
>

> ==
> SQL> CREATE OR REPLACE PROCEDURE PROC(ACCNO number)
> 2 AS
> 3 Open_Bal number(10);
> 4 BEGIN
> 5 select OPENINGAMOUNT into Open_Bal from accountmaster where
> ACCOUNTCODE = accno;
> 6 DBMS_OUTPUT.PUT_LINE(Open_Bal);
> 7 END;
> 8 /
>
> Procedure created.
>
> SQL> execute proc(160000);
>
> PL/SQL procedure successfully completed.
>
>

> ==
> What command I need to write???I have already got the PL/SQL PDF book
> from tahiti.oracle.com.Thanks once again for your great supports.
> Regards
> Arijit Chatterjee

obviously you are very new.

you also needed

drop accountmaster; at line 7, to ensure the table is closed. Received on Wed Dec 01 2004 - 15:47:09 CST