![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
I'm troubleshooting a pl/pgsql function that either inserts a new record, or, if it already exists, updates the record. Very straightforward. Except that it is not working.
I pass an xml document into this function and use xpath expressions to gather data needed in to determine row values for the insert or update. The result will be a couple of those values. The result is null and null.
FRUSTRATING.
Answer. Okay. If you declare "OUT" parameters; don't DECLARE them in the declaration block. Duh.
I pass an xml document into this function and use xpath expressions to gather data needed in to determine row values for the insert or update. The result will be a couple of those values. The result is null and null.
FRUSTRATING.
Answer. Okay. If you declare "OUT" parameters; don't DECLARE them in the declaration block. Duh.
Tags: