Hi.. I am kind of a newbee, created an app about one year ago. Was nice experience, now there is a new challenge for me: creating Phx app holding data in oracle db (there are no other options possible) running with jamdb_oracle as adpater.

It is fairly simple, its just one table.
I just reconfigured it back, running with postgres, it works fine.

Is this oracle DB approach together with phoenix not recommend for “PRODUCTION” or do i just missed come configuration.

I currently get this 'ORA-01008: not all variables bound\n' - error when try to enter a new entity from the frontend or when seeding data into the DB:

[info] POST /limit_classes
[debug] Processing with PcmLimitClassesWeb.LimitClassController.create/2
  Parameters: %{"_csrf_token" => "ACACEyNfFzgHVBQXCQNICwtCDnd6fTlGKqOXT2NLFadaDrpAlt8B8LLu", "limit_class" => %{"abbreviation" => "t", "name" => "TestClass ", "remark" => "this is just a testcase"}}
  Pipelines: [:browser]
[debug] QUERY ERROR source="limit_classes" db=2.5ms idle=1763.0ms
INSERT INTO limit_classes (abbreviation,name,remark,inserted_at,updated_at) VALUES (:1,:2,:3,:4,:5) RETURN id INTO :id ["t", "TestClass ", "this is just a testcase", ~U[2025-02-11 05:59:13Z], ~U[2025-02-11 05:59:13Z]]
↳ PcmLimitClassesWeb.LimitClassController.create/2, at: lib/pcmLimitClasses_web/controllers/limit_class_controller.ex:18
[info] Sent 500 in 31ms
[error] ** (DBConnection.ConnectionError) 'ORA-01008: not all variables bound\n'
    (ecto_sql 3.12.1) lib/ecto/adapters/sql.ex:1096: Ecto.Adapters.SQL.raise_sql_call_error/1
    (ecto 3.12.5) lib/ecto/repo/schema.ex:837: Ecto.Repo.Schema.apply/4
    (ecto 3.12.5) lib/ecto/repo/schema.ex:416: anonymous fn/15 in Ecto.Repo.Schema.do_insert/4
    (pcmLimitClasses 0.1.0) lib/pcmLimitClasses_web/controllers/limit_class_controller.ex:18: PcmLimitClassesWeb.LimitClassController.create/2
    (pcmLimitClasses 0.1.0) lib/pcmLimitClasses_web/controllers/limit_class_controller.ex:1: PcmLimitClassesWeb.LimitClassController.action/2
    (pcmLimitClasses 0.1.0) lib/pcmLimitClasses_web/controllers/limit_class_controller.ex:1: PcmLimitClassesWeb.LimitClassController.phoenix_controller_pipeline/2
    (phoenix 1.7.18) lib/phoenix/router.ex:484: Phoenix.Router.__call__/5
    (pcmLimitClasses 0.1.0) lib/pcmLimitClasses_web/endpoint.ex:1: PcmLimitClassesWeb.Endpoint.plug_builder_call/2
    (pcmLimitClasses 0.1.0) lib/plug/debugger.ex:136: PcmLimitClassesWeb.Endpoint."call (overridable 3)"/2
    (pcmLimitClasses 0.1.0) lib/pcmLimitClasses_web/endpoint.ex:1: PcmLimitClassesWeb.Endpoint.call/2
    (phoenix 1.7.18) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.6.6) lib/bandit/pipeline.ex:129: Bandit.Pipeline.call_plug!/2
    (bandit 1.6.6) lib/bandit/pipeline.ex:40: Bandit.Pipeline.run/4
    (bandit 1.6.6) lib/bandit/http1/handler.ex:12: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.6.6) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.6.6) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 4.0.1) gen_server.erl:1120: :gen_server.try_dispatch/4
    (stdlib 4.0.1) gen_server.erl:862: :gen_server.loop/7
    (stdlib 4.0.1) proc_lib.erl:240: :proc_lib.init_p_do_apply/3


or 

$ mix run priv/repo/seeds.exs
[debug] QUERY ERROR source="limit_classes" db=17.0ms idle=19.2ms
INSERT INTO limit_classes (abbreviation,legacy_code,name,remark,inserted_at,updated_at) VALUES (:1,:2,:3,:4,:5,:6) RETURN id INTO :id ["G", 0, "Gate", "Gate", ~U[2025-02-11 06:08:38Z], ~U[2025-02-11 06:08:38Z]]
↳ Enum."-each/2-lists^foreach/1-0-"/2, at: lib/enum.ex:975
** (DBConnection.ConnectionError) 'ORA-01008: not all variables bound\n'
    (ecto_sql 3.12.1) lib/ecto/adapters/sql.ex:1096: Ecto.Adapters.SQL.raise_sql_call_error/1

The facts /code below..

MIGRATION

defmodule PcmLimitClasses.Repo.Migrations.CreateLimitClasses do
  use Ecto.Migration

  def change do
    create table(:limit_classes) do
      add :name, :string
      add :abbreviation, :char
      add :remark, :string
      add :legacy_code, :integer, null: true

      timestamps(type: :utc_datetime)
    end

     create(
    unique_index(
     :limit_classes,
      [:name],
     name: :unique_name
   ))

    create(
   unique_index(
   :limit_classes,
      [:abbreviation],
     name: :unique_abbrev
   ))

  end
end

Schema

defmodule PcmLimitClasses.LimitClasses.LimitClass do
  use Ecto.Schema
  import Ecto.Changeset

  schema "limit_classes" do
    field :abbreviation, :string
    field :remark, :string
    field :name, :string
    field :legacy_code, :integer
    timestamps( type: :utc_datetime)
  end

  @doc false
  def changeset(limit_class, attrs) do
    limit_class
    |> cast(attrs, [:name, :abbreviation, :remark, :legacy_code])
    |> validate_required([:name, :abbreviation])
  end
end

mix.exs

defmodule PcmLimitClasses.MixProject do
  use Mix.Project

  def project do
    [
      app: :pcmLimitClasses,
      version: "0.1.0",
      elixir: "~> 1.14",
      elixirc_paths: elixirc_paths(Mix.env()),
      start_permanent: Mix.env() == :prod,
      aliases: aliases(),
      deps: deps()
    ]
  end

  # Configuration for the OTP application.
  #
  # Type `mix help compile.app` for more information.
  def application do
    [
      mod: {PcmLimitClasses.Application, []},
      extra_applications: [:logger, :runtime_tools]
    ]
  end

  # Specifies which paths to compile per environment.
  defp elixirc_paths(:test), do: ["lib", "test/support"]
  defp elixirc_paths(_), do: ["lib"]

  # Specifies your project dependencies.
  #
  # Type `mix help deps` for examples and options.
  defp deps do
    [
      {:phoenix, "~> 1.7.15"},
      {:phoenix_ecto, "~> 4.5"},
      {:ecto_sql, "~> 3.10"},
      {:postgrex, ">= 0.0.0"},
      {:phoenix_html, "~> 4.1"},
      {:phoenix_live_reload, "~> 1.2", only: :dev},
      # TODO bump on release to {:phoenix_live_view, "~> 1.0.0"},
      {:phoenix_live_view, "~> 1.0.0-rc", override: true},
      {:floki, ">= 0.30.0", only: :test},
      {:phoenix_live_dashboard, "~> 0.8.3"},
      {:esbuild, "~> 0.8", runtime: Mix.env() == :dev},
      {:tailwind, "~> 0.2", runtime: Mix.env() == :dev},
      {:heroicons,
       github: "tailwindlabs/heroicons",
       tag: "v2.1.1",
       sparse: "optimized",
       app: false,
       compile: false,
       depth: 1},
      {:swoosh, "~> 1.5"},
      {:finch, "~> 0.13"},
      {:telemetry_metrics, "~> 1.0"},
      {:telemetry_poller, "~> 1.0"},
      {:gettext, "~> 0.20"},
      {:jason, "~> 1.2"},
      {:dns_cluster, "~> 0.1.1"},
      {:bandit, "~> 1.5"},
      {:jamdb_oracle, "~> 0.5.11"}
    ]
  end