Write a simple Store procedure and pass parameter to it ?
Answers were Sorted based on User's Feedback
Answer / nikhil patel
CREATE OR REPLACE PROCEDURE test_new1(p_vari1 IN NUMBER
. ,p_vari2 IN
VARCHAR2)
AS
v_vari1 table.rollno%type;
v_vari2 table.name%type;
BEGIN
v_vari1 := p_vari1;
v_vari2 := p_vari2;
INSERT INTO table (
rollno
,name
)
VALUES (
v_vari1
,v_vari2
);
END;
/
COMMIT;
-- CALL PROCEDURE IN OTHER PL-SQL BLOCK
BEGIN
test_new1(0127,'nikhil');
END;
/
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sanjay
Create Or Replace Procedure Test(p_Var1 In Number)
As
v_Var1 Number;
Begin
v_Var1 := p_Var1;
Dbms_Output.Put_Line(v_Var1);
Exception
When Others Then
Dbms_Output.Put_Line(Sqlerrm(Sqlcode));
End Test;
/
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / krishna
PARAMETERS <p>[(<length>)] [TYPE <type>|LIKE <obj>]
[DECIMALS <d>]
[DEFAULT <f>]
[MEMORY ID <pid>]
[LOWER CASE]
[OBLIGATORY]
[VALUE CHECK]
[AS CHECKBOX]
[RADIOBUTTON GROUP <radi>]
[NO-DISPLAY]
[MODIF ID <key>].
Is This Answer Correct ? | 0 Yes | 6 No |
How to create a table index in oracle?
What are the differences between blob and clob in oracle?
What is meant by an index?
How data locks are respected in oracle?
diff between DELETE and TRUNCATE?.
14 Answers HCL, Yalamanchili Software,
why dont we assign not null constraint as table level constraint.
What is a sub query and what are the different types of subqueries?
What are cursor?where are they used?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How to create a server parameter file?
How to rename an existing table?
How to delete an existing row from a table in oracle?