OraFAQ Forum: SQL & PL/SQL » Is it possible to declare a local variable (not parameter) inside a Stored Procedure ? Urgent

Home » SQL & PL/SQL » SQL & PL/SQL » Is it possible to declare a local variable (not parameter) inside a Stored Procedure ? Urgent

Sun, 17 March 2002 23:27

Muralidharan
Messages: 5
Registered: March 2002

Junior Member

Is it possible to declare a local variable (not parameter) inside a Stored Procedure ? Urgent

Mon, 18 March 2002 00:54

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

yes it is

create or replace procedure abc as
a number; -->local variable
b varchar2(100); -->local variable
begin
.
.
.
end;

Mon, 18 March 2002 04:11

Muralidharan
Messages: 5
Registered: March 2002

Junior Member

hi ,

Thanks .

kp in tch,
murali

Previous Topic:	TO_CHAR
Next Topic:	Is it possible to call a oracle stored procedure Directly using VB Application ?

Goto Forum:

]

Current Time: Fri Apr 19 04:45:02 CDT 2024