in oracle 10g sw after compiling procedure how to pass
parameter values ,if we (v_empid out number)how to give
empid after successful compilation program.This site exact
suitable for 10g with respect to question & answer same
format , im trying sql browser & sql command prompt using
exec procedure name & respective parameters.
- 1 Answers
- 2201 Views
- I also Faced
- E-Mail Answers
Answer Posted / Bhawana Yadav
To pass parameter values in a compiled Oracle PL/SQL procedure, you can use the EXECUTE statement. Here's an example:
```sql
DECLARE
v_empid NUMBER;
BEGIN
-- Compile and execute the stored procedure
EXECUTE procedure_name(v_empid OUT OUT_VARIABLE);
COMMIT;
-- Assign a value to v_empid
v_empid := 123456;
-- Re-execute the stored procedure with the assigned value
EXECUTE procedure_name(v_empid OUT OUT_VARIABLE);
END;
```
Replace `procedure_name`, `OUT_VARIABLE`, and the actual procedure definition according to your needs.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is inner join faster than left join?
what is schema? : Sql dba
what is bcp? When does it used? : Sql dba
Can delete statement be rollbacked?
what are aggregate and scalar functions? : Sql dba
Can we rollback truncate?
What is the current version of sql?
What is your daily office routine?
what are the advantages of sql ? : Sql dba
Is primary key always clustered index?
how to start mysql server? : Sql dba
What is the current version of postgresql?
how many tables will create when we create table, what are they? : Sql dba
How do I remove duplicates in two columns?
what is collation? : Sql dba
