Is there an issue with Lucee > Postgres. I'm ge...
# luceem
mauzer
03/25/2022, 2:12 PMIs there an issue with Lucee > 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:
m
Michael Schmidt
03/25/2022, 2:15 PMYou 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.
👍 1
Michael Schmidt
03/25/2022, 2:16 PMalso boolean doesn't necessarily match numeric as well..
👍 1
m
mauzer
03/25/2022, 2:28 PMJust done that but ufortunately that didnt work :-(
mauzer
03/25/2022, 2:35 PMJust broke it all done to just one parameter:
<cfstoredproc procedure="dbo.spGetAOID" datasource="#session.dsn#">
<cfprocparam cfsqltype="CF_SQL_INTEGER" value="123">
</cfstoredproc>
mauzer
03/25/2022, 2:35 PMERROR: 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
03/25/2022, 2:35 PMsame error despite matching types
s
Scott Steinbeck
03/25/2022, 6:03 PMa huge gotcha with postgres is casing. is your function named
spgetaoidScott Steinbeck
03/25/2022, 6:04 PMyou may need to lower case your function name to allow it to match.
Scott Steinbeck
03/25/2022, 6:04 PM@mauzer
m
mauzer
03/25/2022, 9:49 PMYep good point but I was aware of that and changed it accordingly but still nothing I'm afraid 😱
s
Scott Steinbeck
03/25/2022, 9:57 PMim curious why there are 28 parameters passed, but the function above only shows 11
m
mauzer
03/30/2022, 8:54 AMI broke it down to just one parameter and still getting the same error