Calling procedure with null value
556329Jul 12 2007 — edited Jul 12 2007Looking for some clarification on how to pass a null value to a stored procedure.
If I'm calling a procedure which takes 5 arguments but one of the 5 arguments may be a null what is the correct syntax in pl/sql?
Do you simply pass the parameter a blank space enclosed by ' ' (single tick marks) as shown below?
Example with the 3rd parameter null
declare
id number;
begin
get_id(1234567, ABC, ' ', 5118, 225893);
end;