| Author |
Callable statement ...?
|
mallikarjun dontamsetti
Ranch Hand
Joined: Mar 18, 2011
Posts: 233
|
|
I am using a callable statement to call a procedure in my oracle database. I have to create a procedure that has to to update the emp table data which has 10 columns.
The procedure may be like this
create or replace procedure(enao in emp.empno%type,nameemp in emp.ename%type,.............) as
begin
-----
------
------
end;
My doubt is if there are more number of columns in a table then i need to mention that column names in parameters .Is there any other way to do it(not metioning the in parameters)?
|
 |
Arun Chidam
Ranch Hand
Joined: May 08, 2006
Posts: 79
|
|
|
Is those additional columns are mandatory fields for your table?, if not you can update only the fields you wanted to update on your table using given SP.....
|
SCJP 1.4, SCWCD 1.4
|
 |
 |
|
|
subject: Callable statement ...?
|
|
|