Is there any know problems with Lucee calling Stored Procedures? I have tried absolutely everything I know but it just doesn't recognise the function. I have tried changing both the procedure call from CF and the Stored Proc itself to lowercase, Removed all the attributes to see if it at least called the procedure but it just doesn't recognise the name call. Also tried calling it in <cfscript> but nothing. So infuriating! If anyone can help solve be massively appreciated. Thanks My code to call the stored procedure <cfstoredproc procedure="dbo.spgetaoid" datasource="#session.dsn#"> Stored Procedure in Postgres: dbo.spgetaoid

I don't think there is any specific issue with Lucee and Stored Procedures. This has to come down to a driver issues. We don't use PostgreSQL but we use UniVerse. That has a jdbc driver that we drop into the lib folder of Lucee and then call "programs" in UniVerse through a stored procedure call. So I know Lucee can call stored procedures.

@Peter Amiri oh right! That's sounds promising!! Where can I get hold of this uniVerse?

Rocket UniVerse is actually a 4GL green screen programming environment with a multi value database of its own. It’s not going to help you with your PostgreSQL issue. https://www.rocketsoftware.com/products/rocket-universe-0/rocket-universe