title: method Name execute This statement does not declare an OUT parameter. Use { ?= call ... } to declare one
body: <p>I had migrated database from Oracle to AWS Aurora PostgreSQL. I saw that all the packages are migrated as Function in PostgreSQL. I used AWS SCT for the Oracle schema conversion to postgreSQL. <strong>Java</strong> is the application middleware.</p>
  
  <p>for example,
  A package and associated stored proc in Oracle <code>pk_audit.sp_get_audit</code> converted to postgreSQL as <code>pk_audit$sp_get_audit</code> with a <code>$</code> symbol.</p>
  
  <p>When I run the web application, I'm getting an error like <strong>method Name execute This statement does not declare an OUT parameter. Use { ?= call ... } to declare one</strong> . </p>
  
  <p>I don't have access to the application, but App team provided weblogic log. It says,</p>
  
  <p><code>Method Name execute org.postgresql.util.PSQLException: 
  This statement does not declare an OUT parameter.Use { ?= call ... } to declare one.
  org.postgresql.jdbc.PgCallableStatement.registerOutParameter(PgCallableStatement.java:205)     weblogic.jdbc.wrapper.CallableStatement_org_postgresql_jdbc_PgCallableStatement.registerOutParameter(Unknown Source</code></p>
  
  <p>package name specified in the Java code is <code>pk_audit.sp_get_audit</code>
  Renamed the Postgres function <code>pk_audit$sp_get_audit</code> to <code>pk_audit.sp_get_audit</code> still facing the issue.</p>
  
  <p>Is there anything I need to do in PostgreSQL DB ? 
  I need advise and help,Thanks.</p>