CODEWITHSUNDEEP
javafunctionpostgresqlnullcallable-statement
MitoCode
MitoCode

Reputation: 327

How to pass null parameter to a function in POSTGRESQL?

i have a question. I have a function called 

fn_Sell(id integer, idCreditCard integer, description varchar)

thats an exameple, is not the all function, but i want to pass NULL, in idCreditCard, the field acepts null, but when i pass null value, 

it said UNKONW kind of parameter (integer, UNKONW , varchar)

i think is cause of integer is not a null type of value.... what can i do?

y use callable statement in java, and for the second parameter i pass null

Upvotes: 0

Views: 2529

Answers (1)

Prashanth Goriparthi
Prashanth Goriparthi

Reputation: 66

I think your issue is that you are passing in String "NULL" instead of NULL value. Both are different. Check what is passed through.

Upvotes: 1

Related Questions