Is there an issue with Lucee gt Postgres I m getting this er

Question

Is there an issue with Lucee gt Postgres I m getting this error when hitting this stored procedure after switching from MS SQL to Postgres The stored procedure executes just fine in Postgres but when Lucee makes the call I get this

Michael Schmidt · Answer

You didn t relate you other post in cfml general but my gut would be you are using cf sql numeric when the datatype in the stored procedure is integer Make sure all your parameters match the type they are going into

Michael Schmidt · Answer

also boolean doesn t necessarily match numeric as well

mauzer · Answer

Just done that but ufortunately that didnt work

mauzer · Answer

Just broke it all done to just one parameter lt cfstoredproc procedure= dbo spGetAOID datasource= session dsn gt lt cfprocparam cfsqltype= CF SQL INTEGER value= 123 gt lt cfstoredproc gt

mauzer · Answer

ERROR function spgetaoid integer does not exist Hint No function matches the given name and argument types You might need to add explicit type casts Position 15 Detail Parameter types passed 1 CF SQL INTEGER SQL call spGetAOID DatabaseName PostgreSQL DatabaseVersion 13 4

mauzer · Answer

same error despite matching types

Scott Steinbeck · Answer

a huge gotcha with postgres is casing is your function named `spgetaoid` all lower case or does it have camel casing in it

Scott Steinbeck · Answer

you may need to lower case your function name to allow it to match

Scott Steinbeck · Answer

< mauzer>

mauzer · Answer

Yep good point but I was aware of that and changed it accordingly but still nothing I m afraid scream

Scott Steinbeck · Answer

im curious why there are 28 parameters passed but the function above only shows 11

mauzer · Answer

I broke it down to just one parameter and still getting the same error