Hi

The current update store procedure that I have updates a list of input provided, but it there are fields that are left blank, they are being updated as null in the database.
I'm having a trouble creating a store procedure that will just update the provided fields only.

Please Help
Thanks

If the procedure doesn't work what you want, it is probably because you wrote it incorrectly. As you didn't provide code, tables, data, etc., it is difficult to guess what might be wrong. A blind guess: WHERE clause is a culprit.

Have you considered using proper WHERE clause to UPDATE only rows with "the provided fields only"?

I have lot of fields, that might be updated on the run time. Now I'm struggling with a query for that, run time update.

My current update would look like this:

create or replace PROCEDURE SP_UPD_EXCEPTION_LOG
(
p_ExceptionID IN INTEGER,
p_DateTimeStamp IN DATE,
p_Code IN VARCHAR2,
p_Description IN VARCHAR2,
p_Information IN VARCHAR2,
p_ApplicationID IN INTEGER,
p_rowID OUT NUMBER
)

AS

BEGIN
UPDATE "ExceptionsLog"
SET
"DateTimeStamp" = SYSDATE,
"Code" = p_Code,
"Description" = p_Description,
"Information" = p_Information,
"ApplicationID" = p_ApplicationID

WHERE "ExceptionID" = p_ExceptionID;

END SP_UPD_EXCEPTION_LOG;


but now if a user might update only two fields from that code, others are updated as null.

>but now if a user might update only two fields from that code, others are updated as null.

so you need to modify the procedure to do as you desire.
try using IF ... THEN